[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Migrating SQL Server databases to Azure using SSMS 2012

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Migrating SQL Server databases to Azure using SSMS 2012


Applies to: Microsoft SQL Server 2012 Enterprise Edition.


If you are planning the migration of SQL Server databases to Windows Azure, SQL Server 2012 Management Studio (SSMS) provides you a great wizard to perform this task in just a few minutes. Below you will find the procedure to this migration.

1. Create a database server on Windows Azure.





2. Connect to the Windows Azure database server as shown below.





3. Connect to the SQL Server instance located on your LAN or local computer.





4. Make a right click on a database on your SQL Server instance that you would like to migrate to Windows Azure. Make a click on “Tasks” then select “Deploy database to SQL Azure…” For this procedure we are using an old SQL Server 2000 database named Pubs that we previously upgraded to SQL Server 2012.







5. Click on the Next button on the Introduction dialog of the wizard.






6. On the Deployment Settings dialog of the Wizard, click on the Connect button to provide credentials and get connected to the SQL Azure database server. Once the connection has been established, click on the Next button.















7. A summary of all the options you have chosen will appear on the Summary screen. Make a click on the Finish button.



 






On the process of exporting the database to the SQL Azure server, we received the following error:


One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71564: Table Table: [dbo].[roysched] does not have a clustered index.


SQL Azure does not allow the creation of tables that don’t have a clustered index. We created clustered indexes on an identity column we added to each table. We then re-run the Wizard again and the migration process finished successfully.












We ran a simple SELECT statement on the database we just migrated to the Windows Azure database server using SSMS.





Let’s confirm the Pubs database now exists on the Windows Azure database server.




 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.