Automating "Script Database"

Question

Automating "Script Database"

Barkingdog

SSCoach

Points: 18670
More actions
June 28, 2004 at 1:59 am

#102081

How can I automate (i.e. schedule) the "All Tasks > Generate Scripts" (including logins, permissions, schema, etc) for each database on a sql 2k server?
Bill

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

The only way I know for sure of is using SQL-DMO. However I don't have an example getting that much detail at one time. Can provide a sample for scripting tables and indexes as an example.

Barkingdog SSCoach Points: 18670 More actions · Answer 2

Antares686,

If you will, please post your SQL-DMO for the tables and indexes. May save me a lot of work and if I expand upon it in any significant way I'll submit it to this website.

Bill

Derrick Leggett SSCrazy Points: 2778 More actions · Answer 3

You can find the script here:

http://www.nigelrivett.net/

Bookmarks are a great thing to have.

Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.

mark baekdal-145375 SSCrazy Points: 2200 More actions · Answer 4

I'll ask the question: Why do you want to automate the scripting of your database?

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 5

take a look at :

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107508

"C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yourserver /d yourdatabase /I /F c:\yourfile

rem SCPTXFR /? - Command line help.

rem

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me