Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-05-31 : 13:10:17
|
| Hi Experts,I need small information from you. I got some table which are in SQL Server 2008r2 which support some application, now one of the developer is asking me to take all those and put in a new database.the tables might be around 100's, Please let me know is there any way to take a backup of those tables and restore it in the new database.Or else is there any way moving or copping the table with the data into the new database. Thank you in Advance. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-05-31 : 13:19:24
|
| You could use ssis to transfer objects.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-05-31 : 13:30:29
|
| Thank you for your quick response Nigelrivett, but sorry to say that i have no idea how to transfer objects using ssis. Please let me know how to do that or else let me know if there is any other way to do so.Thnak you, |
|
|
|
|
|
|
Backup tables