To Script database through a command

Question

Post reply

To Script database through a command

krishna-414804

Grasshopper

Points: 17
More actions
November 28, 2007 at 1:56 am

#118983

Is it possible to script the entire database through a command or a query
Plz help me...
regards,
Krishna

Viewing 8 posts - 1 through 7 (of 7 total)

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

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 1

Hi krishna,

Use SSMS, in the Object Explorer, Right click on your database, choose task the generate script.

Just follow the wizard script instructions.

Regards,

Ahmed

noeld SSC Guru Points: 96590 More actions · Answer 2

you could try powershell scripts which are callable from TSQL also.

* Noel

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 3

SQL_ABD

SSCertifiable

Points: 5832

November 28, 2007 at 2:00 pm

#755134

Sorry Noeld

What do yoy mean exactly

StarNamer SSCrazy Eights Points: 8746 More actions · Answer 4

As it happens, I found a tool for doing exactly this yesterday.

http://www.codeplex.com/ScriptDB

I will even dump bcp extracts of the data for you if required.

Derek

iceheartjade Say Hey Kid Points: 677 More actions · Answer 5

I found something works really well. It calls the extend store procedures SP_OA....

http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html

Prakash Heda SSCertifiable Points: 5539 More actions · Answer 6

script ut the database from SSMS and then use sqlcmd to run it from command line....u can customise script to accept various parameters from sqlcmd

Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA

StarNamer SSCrazy Eights Points: 8746 More actions · Answer 7

iceheartjade (11/29/2007)
I found something works really well. It calls the extend store procedures SP_OA....
http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html

The drawback with this is that is both the OLE Automation Procedures and xp_cmdshell are disabled by default for security reasons. ScriptDB just uses the same functions from C#.

Derek