Data Migration using DTS or any other method

• Priya Mittal

  Newbie

  Points: 6

  More actions

  October 4, 2005 at 12:59 am

  #363816

  Hi,

  I want to transfer data from one database to the other.In my current database , i have large no. of records.In most of the Tables,I maintain ISDeleted Field which is of bit type. If this value of a record with IsDeleted is equal to 1 means that record is deleted & not currently in use.If the value is 0 that means record is not deleted.

  Now I want to move all the tables & records with Deleted fields (IsDeleted = 1) to another database & delete those records from my Current database.

  & further if possible Provide a link or some feature  in current database to map to the new Database.

  I cannot write query for individual tables as the no. of tables is quite large.

  Any help & Suggesstions???

  Thanx & Regards,

  Priya Mittal

   

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  October 4, 2005 at 3:02 am

  #594752

  Please do not submit the same post in multiple forums.

  Use this link for answers to this question:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=225720

  ---