Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the supported methods of moving data between on-premise SQL Server and SQL Azure?

April 26, 2017azure Data methods moving on-premise sql SQL Server supported

0

10 Posted

What are the supported methods of moving data between on-premise SQL Server and SQL Azure?

1 Answer

0

10 Posted

There are several ways to migrate data between on-premise SQL Server and SQL Azure. • SQL Server Integration Services (SSIS) can be used with ADO.NET connection managers with parallelism enabled for improved performance. You may also script your data depending on the size and needs. • An unsupported scripting tool, SQL Azure Migration Wizard, developed by the community is also available from Codeplex. • Bulk Copy utility (BCP): You can use BCP to migrate your data from on-premise SQL Server to SQL Azure or vice-versa. • You may also use the Generate Scripts Wizard with SQL Server Management Studio 2008 R2 and to script your database. • In SQL Server 2008 R2 or later, the Import or Export wizard provides support for SQL Azure Databases using the .Net provider for SQL Server. See Exporting Data from SQL Azure: Import/Export Wizard for more information. • Also, please review the demo about migration data from on-premise to SQL Azure included in Windows Azure Training kit.