Generating schema SQL scripts via command line. 
Author Message
 Generating schema SQL scripts via command line.
Anyone:

Is there a way to generate schema sql scripts for a database via command
line instead of via Enterprise Manager which I know how to do.  I would like
to schedule a NT batch file that would BCP and Generate the db schema on a
recurring basis. The script would be generated for tables, views, defaults,
rules, stored procedures, (all db objects).  This would be useful for
restoration of dropped objects and the BCP for the data.

Thanks,
Jim Phillips
DBA



Sat, 31 Aug 2002 03:00:00 GMT
 Generating schema SQL scripts via command line.

Jim,

Check out the SQLDMO API. It has functionality to generate schema, as well
as BCP.

--
Tibor Karaszi, Cornerstone Sweden AB
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Please reply to the newsgroup only, not by email.
By providing DDL where appropriate, you're more likely to get a (good)
response.


Quote:
> Anyone:

> Is there a way to generate schema sql scripts for a database via command
> line instead of via Enterprise Manager which I know how to do.  I would
like
> to schedule a NT batch file that would BCP and Generate the db schema on a
> recurring basis. The script would be generated for tables, views,
defaults,
> rules, stored procedures, (all db objects).  This would be useful for
> restoration of dropped objects and the BCP for the data.

> Thanks,
> Jim Phillips
> DBA



Sat, 31 Aug 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Generate SQL for schema via command line?

2. Command line syntax for generating SQL Scripts

3. How to run SQL scripts via command-line?

4. Generate SQL Script via SQL Agent Jobs

5. generating schema scripts programetically in SQL 7.0

6. PLEAD for SQL schema scripts to generate databases for testing

7. SQL - Generate Scripts Blank Lines Bug

8. SQL - Generate Scripts Blank Lines Bug

9. SQL connection via command line

10. sql sqripts via command line

11. Generate SQL Scripts command is freezing at 22%


 
Powered by phpBB® Forum Software