Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Script to do Schema Dump
- Thread starter GuySmiley
- Start date
tlbroadbent
MIS
T-SQL doesn't provide a direct way to script a database. You can use SQL DMO. See SQL BOL and the Microsoft website for details about SQL DMO.
I have some VBA modules usin SQL DMO that I execute from Access to script our SQL databases. I send the code to you if you are interested. I hope to convert the modules to VB script soon so I can run scripting jobs on each server.
There is a freeware product called "SQL DevPro" which is supposed to provide scripting. I just installed it but have had difficulty getting it to work on one of my databases. You may want to download and try it.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
I have some VBA modules usin SQL DMO that I execute from Access to script our SQL databases. I send the code to you if you are interested. I hope to convert the modules to VB script soon so I can run scripting jobs on each server.
There is a freeware product called "SQL DevPro" which is supposed to provide scripting. I just installed it but have had difficulty getting it to work on one of my databases. You may want to download and try it.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question