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

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.
Posted

create an SSIS package for this data migration if possible , its easy,fast and support SQL server databases
 
Share this answer
 
Comments
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
   SELECT *
   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