Post reply

Maintaining Relationships During Conversion

  • March 17, 2008 at 9:53 am

    #184158

    I am converting multiple database schemas into one database. The data is mapped but I am wondering how I am going to maintain the data relationships upon conversion. Does anyone have a strategy for this or know of an article/book that does?

    Thanks,

    cj

  • March 17, 2008 at 10:03 am

    #790429

    I've moved objects between databases by either scripting them in Enterprise Manager (including foreign keys) and running the scripts in the destination database or by using the Copy SQL Server Objects task in DTS. Either one will maintain referential integrity between tables.

    Greg

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

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