The error message indicates your user does not have permission to create a new table in the database "rdsadmin".
Check to see if the "rdsadmin" database exists, and has the correct privileges for the user you're trying to execute the commands as.
Troubleshooting:
For SQL Server you probably want someting like this:
Add the current admin user to SQL Server Express 2008
CREATE LOGIN [domain\username] FROM WINDOWS;
GO
EXEC sp_addsrvrolemember 'domain\username', 'sysadmin';
GO
For MySQL:
- rdsadmin is the admin user that gets created with RDS and has all global privileges (on localhost only). This is only for use by AWS/RDS, not by you.
- when I created a db/user in the RDS setup wizard my user 'test' was created, this had most global privileges (on %).
None of these accounts had any specific privileges granted on any database. You should explicitly grant privileges as you require them.
I would generally do this by logging in (either in terminal or by using a GUI like Sequel Pro) and executing the required privilege. In this example i would log into mysql with my 'test' user.
Once logged in, you can run the required MySQL commands:
http://kb.mediatemple.net/questions/788/HOWTO%3A+GRANT+privileges+in+MySQL#dv
or http://library.linode.com/databases/mysql/arch-linux have examples of this, but here is a quick example:
CREATE DATABASE testdb;
CREATE USER 'testuser'@localhost IDENTIFIED BY 'CHANGEME';
GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@localhost;
Of course you will have to substitute with the proper database/user-name/password (you can skip db/user create commands if the db or user already exists).
You may want to grant a privilege only on localhost, or something different depending on what you're trying to achieve.
Best Answer
In the documentation for Modifying a DB Instance to Use a Different Storage Type there is the following note:
And as you say, you can't restore a snapshot into another storage type.
I think your best option is your number 3. Export your database, and then import it on your new RDS instance.
Leaving RDS for a self hosted variant in EC2 seems a bit drastic since changing storage type isn't really something you do every day, my guess is that this is your first and last time that you do it. The features that comes out of the box with RDS are simply too overwhelming for changing to a self hosted solution, in my opinion at least.