How do I create sql scripts sql server 2008?
Posted on 2009-05-19
I do not want to go through table by table, function by function, etc. and create a single script for each. I am aware of how to do that. I need to copy pieces of the database to another database. Not everything either so I cannot do a backup and restore type operation.
Can anyone help me here please?
In Oracle I could go into TOAD and select 1,000 objects and script them to a file/clipboard very easily. How can I accomplish this in SQL Server 2008?
Any help would be greatly appreciated.
Thanks in advance,