rajarao.m
SSC Veteran
Points: 241
More actions
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.?
matak
SSCrazy
Points: 2674
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