Post reply

copy table

  • January 29, 2008 at 10:36 am

    #182376

    I would like to copy the existing table with data and other constraints attached to a new table.

    How do i do it?

  • January 29, 2008 at 12:56 pm

    #773035

    Assuming that your database that contains the table is set to 90 Compatibility (SQL 2005)

    1. This is an assumption that you need to create the table and that the table is identical. In Studio Manager find the table highlight right-click Script Table as/Create To New Query Editor window

    2. Take the table script and run the create table in the destination database

    3. In the Source database (not table) right-click and choose Export Data

    4. This will bring up the Export/Import Wizard, follow the steps to export a copy of the data from the original table to the destination table

  • January 29, 2008 at 3:47 pm

    #773074

    After step 2, you can also use a simple insert statement instead of following import/export wizard. this is only possible if you are running this statement on same server or linked servers.

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

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