Generate scripts for all databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Generate scripts for all databases

Generate scripts for all databases

Rate Topic

Display Mode

Topic Options

Author

Message

ramadesai108

Posted Tuesday, December 07, 2010 1:18 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, February 27, 2013 1:38 PM
Points: 370, Visits: 670

How do I generate scripts for all objects in all databases for a particular instance.

Thanks.

Post #1031478

ALZDBA

Posted Tuesday, December 07, 2010 1:27 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 6,861, Visits: 8,046

have a look at:

"C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yoursqlserver\instance /d yourdb /I /F c:\yourscriptfolder

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

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

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

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

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

Post #1031489

« Prev Topic | Next Topic »

Permissions