Post reply

Data Transfer - from denormalized database to normalized database

  • February 16, 2011 at 12:18 am

    #246704

    [font="Arial"]

    Dear All,

    I am preparing for a new assignment of data migration. I would like to take your help and advice to achieve the data migration in best way.

    Case is like

    Source database is SQL Server 2000 and target would be SQL Server 2005. The source database is entirely de-normalized. A Table which stores the data, which needs to be migrated, in key-value format. Ex.

    PageIDColumnsValue

    1FNameXYZ

    1Phone12344545234

    1EmailIDabc@lmn.com

    1AddressAsdfasdfasdfas

    And target database tables will be like

    Basic information

    PAgeID FnamePhone EmailID

    1XYZ12344545234abc@lmn.com

    Address information

    PageIDAddress

    1Asdfasdfasdfas

    A single table values are gone to two different tables.

    I am trying to achieve this with T-SQL Script. Please let me know if you know any better way to that.

    Thanking you in advance.

    [/font]

  • February 16, 2011 at 9:01 am

    #1287741

    not sure what you are wanting.

    Depending on the amount of data being transferred you might want to go thru export wizard or ssis

    but t sql would probably be quickest way

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply