Generate SQl Script

Question

Post reply

Generate SQl Script

Viewing 4 posts - 16 through 18 (of 18 total)

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

Manie Bloem SSC Enthusiast Points: 193 More actions · Answer 1

Thanx for all your help. I will try it but was actually also looking for SQL code like the previous examples.

Manie

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 2

You can also use scptxfr.exe to script. This can be found in the upgrade directory. If you want to do it via t-sql then execute this via xp_cmdshell.

c:\mssql\upgrade\scptxfr.exe /s <your server> /d pubs /q /I /F c:\temp\db.sql

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

stanislavpetkov SSC-Addicted Points: 474 More actions · Answer 3

You can investigate what EM does when scripting objects by starting a trace and scripting the objects at the same time. You will see what SPs are being used and then you can build your pure SQL server solution.

Stanislav Petkov

5409045121009-7368 SSCoach Points: 15740 More actions · Answer 4

Also used scptxfr.exe and script to yyyymmdd_hhmm file for historical purposes with a small team. With a bigger team used VB/SQLDMO which updated SourceSafe a file. Handy to compare, between release, what was changed in the database.