Post reply

Script to copy data from one database into another

  • June 1, 2009 at 1:41 pm

    #205382

    I have a DB with 150 tables on my Development environment...

    I want to export data of 100 tables from that database to my production database...

    I did it with RedGate and it works (testing on dev environment), but its too slow to select 100 tables (one by one) to do the export..

    Is any Script can do Data Export ??? It will be easy to run the Script or the package...

    Regards,

  • June 2, 2009 at 2:03 am

    #1003217

    Hi,

    You can do that using export wizzard from Mamagement Studio. Also, wizard can create SSIS package. Doing that way it will be fast and clean 🙂

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

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