moving data only from branch to branch by text file

• ahmed_elbarbary.2010

  Hall of Fame

  Points: 3118

  More actions

  May 7, 2012 at 12:54 am

  #273585

  I have sql server 2005 standard edition sp2 installed and configured in two branches but not in same network. this two branches have two databases

  first branch database A

  second branch database B

  if i want to moving all data exist in all tables from database A to database B daily how can i make this

  Notes

  Two databases A,B have same structures and schema every thing but different

  only in data.

  Two branches not connected each other online by vpn or any thing .

  what i need is practical solution to export all data(not objects) from database A to text file then import these data from this text file to database B are this possible if possible how

  please help me

  thanks

• srikant maurya

  Hall of Fame

  Points: 3293

  More actions

  May 7, 2012 at 1:08 am

  #1483973

  Use SSIS Package

  1. Develop SSIS package to extract the data in csv/text file

  2. Copy the csv/text file on second server (using FTP or some other method upto you)

  3. Develop a new package to load (apply all the rule)the data from csv/text file