Post reply

how to copy all the scripts one sql server database server to another sql server database

  • March 26, 2013 at 12:06 am

    #272146

    Dear all,

    Hope you doing...,

    actually i am changing all my tables from 10.101.__.17.dailyreps database name to another server 10.101.--.23.daily reps.

    i copied all the tables successfully,now i am having multiple scripts in my database of source i want move all the scripts into my destination data.

    can you please how it is possible all at a time other than manually copying and paste one by one.?

  • March 26, 2013 at 1:10 am

    #1600620

    One way of doing this is to open up SSMS.

    Right click on your database name.

    Choose tasks then GEnerate scripts.

    Go through the wizard and have it generate a sql file or a script in a new window.

    You can then run this against your new database.

  • March 26, 2013 at 1:26 am

    #1600622

    Thank youm, i have done.

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

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