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 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.