I'm searching for an order line program that extracts a script that contains instructions for masterpieces of database objects (tables, sights, methods, machines, types). It will use MySQL, Firebird, Oracle and MS SQL Server.
As part of our automatic build process we wish to place in our SVN repository a script for database creation within an automatic fashion. Firebird has a tool which do what we should want but we should you prefer a generic one therefore we may include being an ANT task.
For SQL Server you should use the Database Publishing Wizard I can not assist you with another DB's, however. Best Of Luck.
To Script the Schema and Data
sqlpubwiz script -d YourDB -S YourServer -U YourUsernam -P pwdhere C:\DestFile.sql
and also to just script the Schema
sqlpubwiz script -d YourDB -S YourServer -U YourUsernam -P pwdhere C:\DestFile.sql -schema