Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to restore sqlserver 2005 db on Sql Azure. Expand / Collapse
Author
Message
Posted Monday, March 26, 2012 8:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 17, 2013 12:26 AM
Points: 8, Visits: 52
Hi All,

Could any help me any way by which i can transfer/upload data of sql server 2005 not 2008 to sql azure?

Regards,
Vijay
Post #1272681
Posted Monday, April 23, 2012 2:29 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, March 13, 2014 8:36 AM
Points: 698, Visits: 506
A simple Google search turned this up.

http://msdn.microsoft.com/en-us/library/windowsazure/ee730904.aspx

Looks like there are several ways to do it - the following is a copy and paste from the hyperlink:


Migrating Databases to SQL Azure by Generating a Script of an Existing Database

To migrate an existing SQL Server database to SQL Azure you can export the schema as a Transact-SQL script and then execute that script against SQL Azure Database as follows:

Export a script from SQL Server Management Studio and set the appropriate export options. Because SQL Azure Database supports a subset of features found in SQL Server, you may have to make some modifications to the script before you are able to execute it in the cloud.

Execute the script to create the schema in SQL Azure Database.


"Be brave. Take risks. Nothing can substitute experience."
Post #1287987
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse