June 8, 2011 at 10:35 am
Hi All,
I have 500+ tables in one database. Out of them I would like to script out about 230 tables as I am creating the same tables on another database. What would be the best approach? I tried generate scripts wizard but it will take too much time for me to select individual tables.
any suggestions?
Thanks in advance...
June 8, 2011 at 10:37 am
No way around that one.
You could possibly copy everything then use a script to drop what you don't need. "might" be faster but since you keep roughly 50% of the objects I don't really see the advantage.
The 1 thing I like better about option 2 is that you only have to make the exclude list once, then you can rerun a script... but then again you can save the wizard's package into ssis for re-runs.
June 8, 2011 at 11:40 am
Thanks...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply