Migrating local database from app_data folder to SQL Azure

Question

I have a database in the app_data folder of an asp.net website on my local machine. I'm now trying to migrate that database to SQL Azure using the SQL Azure Migration Wizard. Here's my issue. The Migration Wizard only sees the databases that I have on my local sql server. It does not see the database in my application's app_data folder and I can't figure out how to connect to it. Is there a way to get the migration wizard to see this database? Or, is there an alternative way I can migrate this database? I already tried scripting the database from within VS. Unfortunately the script failed to execute on Azure because of differences in the way that SQL Azure & regular SQL Server work. I know that from past experience the Migration Wizard resolves these differences easily.

Dennis Traub · Accepted Answer · 2011-10-14 14:59:14Z

1

Run the script you created in VS on your local SQL Server to create the DB locally
Use the SQL Azure Migration Wizard to create the new script from the DB you created in 1.

or

Attach the DB in app_data as a SQL Server DB using SQL Server Management Studio
Use the SQL Azure Migration Wizard to create the new script from the DB you attached in 1.

answered Oct 14, 2011 at 14:59

Dennis Traub

51.9k7 gold badges100 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hughesdan Over a year ago

Thanks. That was easy...don't know why I didn't think of it.

Collectives™ on Stack Overflow

Migrating local database from app_data folder to SQL Azure

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related