Post reply

Database to Database?

  • May 23, 2002 at 8:51 am

    #79115

    I'm very new to this game and have been given the job of moving data from our old production database to a new test database where all the old tables have been normalized. What would be the best way to do this DTS or by using T-SQL scripts? Is it possible to update a table in one database with data from another database using T_SQL?

    Thanks

  • May 23, 2002 at 10:55 am

    #429676

    DTS is easier exspecially when mapping the data. However to answer your secod question you would need to create a linked server to get the best results then TSQL can do exactly what you are asking about.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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