November 13, 2002 at 7:07 am
Hello,
Does anyone know of a way that I can schedule a job / DTS package that would script out all database objects every night? I looked through the Scripts section of this website and found a VB script. Does anyone have a SQL script instead?
Thanks!
Melanie
November 13, 2002 at 10:25 am
There isn't a good way in SQL to script out everything. There are ways to get at the data, but no easy way to script them. Is there a reason why VBScript won't work?
Steve Jones
November 13, 2002 at 11:55 am
Hi Steve,
I just thought the VBScript would be more difficult than it actually is. I just tried it and the script worked perfectly.
Thanks!
Melanie
November 13, 2002 at 4:41 pm
you are welcome. It's one area we need some more articles to let people know how easy it is. Glad it worked for you.
Steve Jones
November 14, 2002 at 6:18 am
Do you know of any good articles that explain how to use vbscript to script out your database objects?
Thanks,
Billy
November 14, 2002 at 5:41 pm
Have you considered using Bill Wunder's DDL Archive Utility for SQL Server? It rocks..scripts out all object on the server and stores them in Source Safe.
November 15, 2002 at 6:14 am
I have not tried it, but I will defiantly download it and give it a try.
Thanks,
Billy
November 15, 2002 at 9:48 am
Bill's tool is great, but it doesn't work with SQL 6.5. Anything similar to Bill's tool out there that will work with 6.5? Also, I couldn't find the VB script discussed above, can someone please point me to a link? Thanks!
Forever learning,
Jeff
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply