Custom Data Transfer from old un-normalize DB to new normalize DB (w/ new schema)

• johntyung

  Newbie

  Points: 3

  More actions

  October 5, 2011 at 9:25 pm

  #246085

  Greetings and Dear All,

  my boss wants me to do a Data Transfer from an old SQL Server DB to a new SQL Server DB.

  the issue is, the schema in the new DB is highly normalized where the data will be stored in such a way that many lookup table are used unlike the old un-normalized DB where alot of data is bunch into one table.

  my boss wants me to write a Windows program to essentially marshall, transform and transfer the data from the old unnormalized DB to the new normalized DB with lookup tables for datatypes. In addition, he wants me to using an XML file for mapping the various columns from the old to the new db.

  i never done this before, if u guys have experience and ideas on this, please provide some pointers, tutorials, sample codes and such.

  Pls help.... 🙂

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  October 6, 2011 at 3:27 am

  #1391108

  Why write your own windows applicaiton to do this, when you could jsut use SSIS and save yourself weeks of work.