Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
borntodeal
Starting Member
2 Posts |
 Posted - 2011-01-29 : 20:34:50
|
| I would like to host my SQL in the cloud. I would like to find an easy open source tool that will clone or mirror my local server's database to the SQL Azure. I tried the free studio MS offers and it won't connect to SQL Azure.Can you suggest a program that does this?The Spencer Company1130 North Lima StreetBurbank, California 91505Phone: (818) 567-4000Fax: (818) 567-0026www.spencercompany.com |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-01-31 : 22:47:36
|
| Download and install SQL 2008 R2 management Studio.. connect to your on-premise instance of SQL Server, right click on database > Generate scripts > in the advanced options choose SQL Azure for engine type. The wizard will generate a script compatible with SQL Azure. There is also a free tool on codeplex called SQLAzureMigrationWizard which does the same and it can transfer data as well.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL Server 2005 to SQL Azure