Click here to Skip to main content
15,846,727 members
Please Sign up or sign in to vote.
0.00/5 (No votes)

I have migrated my schema using SQLAzureMW tool to my azure server, as I am having huge data to copy from source to destination server. the SQLAzureMW BCP takes too long time.
Please suggest best way to copy only data from source to destination server.

create an SSIS package for this data migration if possible , its easy,fast and support SQL server databases
Share this answer
VijayVictorious 26-Nov-15 3:52am    
SSIS, Import and export wizard is fine, is there any way like Robo copy commands to copy only data..
At first you need to create a table on the targeted server using the scripts from the
Script Table As / Create Script 

then issue this T-SQL statement on targeted Server

INSERT INTO dbo.TableName
   FROM [SourceServer].[SourceDatabase].dbo.TableName
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900