Command line syntax for generating SQL Scripts 
Author Message
 Command line syntax for generating SQL Scripts
Hi all

Is there any command line statement  for generating SQL
Scripts(For Stored Procedures and User Defined Functions)
from DOS prompt?

If so please help...

Thanks in advance

Anand



Sun, 19 Dec 2004 02:48:47 GMT
 Command line syntax for generating SQL Scripts

Hi!

Distributed Management Objects (DMO) can do the scripting. So if you create
a VB script using DMO, this could be your command-prompt scripting utility.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



Quote:
> Hi all

> Is there any command line statement  for generating SQL
> Scripts(For Stored Procedures and User Defined Functions)
> from DOS prompt?

> If so please help...

> Thanks in advance

> Anand



Sun, 19 Dec 2004 06:28:27 GMT
 Command line syntax for generating SQL Scripts
If you want sp's and UDF's...  you could call the sp_helptext procedure from
a command line OSQL session. OSQL is a command line query tool...

--
Brian Moran
SQL Server MVP



Quote:
> Hi all

> Is there any command line statement  for generating SQL
> Scripts(For Stored Procedures and User Defined Functions)
> from DOS prompt?

> If so please help...

> Thanks in advance

> Anand



Sun, 19 Dec 2004 03:52:38 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Generating schema SQL scripts via command line.

2. Generate SQL for schema via command line?

3. SQL - Generate Scripts Blank Lines Bug

4. SQL - Generate Scripts Blank Lines Bug

5. Generate SQL Scripts command is freezing at 22%

6. Running SQL scripts from the command line on NT

7. How to run SQL script was command line.

8. Command line utility for SQL Scripts

9. SQL Script from Command Line

10. run sql script from command line?

11. Running SQL scripts from command line.


 
Powered by phpBB® Forum Software