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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy