Post reply

Export tabels

  • June 6, 2011 at 3:10 pm

    #241651

    I am asked to export tabels from one DB to another DB on the same instance with current Schema. CanI get some help as I need to finish it today?

    So far I figured I can do it with DTS import/export wizard, but I am not able to figure out how to with the current schema.

    Thanks

    SV

  • June 6, 2011 at 3:13 pm

    #1334686

    The simplest way is to right click on the 'source' database, select All Tasks and then pick 'Export Data' and follow the wizard. One of the steps allows you to map the to/from fields and data types if the schemas are different.

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph

  • June 6, 2011 at 3:17 pm

    #1334688

    Thanks!

  • June 6, 2011 at 3:20 pm

    #1334689

    The tables and the schema do not exist on the destination? Then how can it be done?

  • June 6, 2011 at 3:27 pm

    #1334697

    Just follow the wizard. If the table doesn't exist, it'll create it. You should test this between two test databases before using this in production.

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph

  • June 6, 2011 at 3:33 pm

    #1334702

    Thanks!

Viewing 6 posts - 1 through 5 (of 5 total)

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