October 12, 2010 at 8:43 am
How can i script the database (has partition scheme,function with 100's of fiel groups) and all its objects. I have tried scripting from the task menu but its does script out function and scheme?
October 12, 2010 at 9:02 am
Maybe use SQLCompare and compare it to an empty database ?
October 12, 2010 at 10:07 am
There are many great 3rd party tools (with fully functional demos) which will do this. I've found the microsoft built in scripter to be a little "clunky".
My personal favourite is ApexSQL Script.
October 12, 2010 at 10:07 am
What are you trying to accomplish? Recreate an empty db? SQL Compare will work, as will a backup and restore ,and truncate all tables.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply