Post reply

data transfer

  • October 1, 2003 at 7:22 am

    #162552

    I need to transfer data from one database to another on sql server 2000 on the same server. There are about 100 tables to copy in total. Approx. 10 tables have a slightly different schema.

    What are some ways to transfer this data?

  • October 1, 2003 at 10:04 am

    #476581

    Hi,

    try using the Export data wizard, this can do multiple tables and if you can configure transformations for tables that have different columns. just right click on the database name and select all tasks, then export data wizard

    HTH

    Paul

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

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