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

  • Question

  • 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.... :)

    Thursday, October 6, 2011 3:16 AM