August 12, 2014

Data Migration from SQL Server to SQL Azure

Data Migration from SQL Server to SQL Azure
You can transfer data to Microsoft Azure SQL Database by using the following:
  • SQL Server 2008 Integration Services (SSIS) 
  • The bulk copy utility (BCP.exe)
  • System.Data.SqlClient.SqlBulkCopy class
  • Scripts that use INSERT statements to load data into the database
Microsoft Azure SQL Database does not support:
  • The RESTORE statement.
  • Attaching a database to the Azure SQL Database server.

No comments:

Fashion Catalog Similarity Search using Datastax AstraDB Vector Database

DataStax Astra DB's vector database capabilities can be leveraged to build an efficient fashion catalog similarity search, enabling user...