Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to restore sqlserver 2005 db on Sql Azure.


How to restore sqlserver 2005 db on Sql Azure.

Author
Message
k.vizay
k.vizay
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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
Robin Sasson
Robin Sasson
Right there with Babe
Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)

Group: General Forum Members
Points: 769 Visits: 530
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.

Exclamation "Be brave. Take risks. Nothing can substitute experience." Exclamation
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search