<div>
As I mentioned in the question, I need a mechanism which could be executed in a script, without human intervention.
</div>


As I mentioned in the question, I need a mechanism which could be executed in a script, without human intervention.

<div>
SMO sounds like a promising solution. Yes, code would be very helpful.
</div>


SMO sounds like a promising solution. Yes, code would be very helpful.

<div>
I can write code for you, but it might take time. you can read the article below and help yourself - <br />
<br />
<a href="http://philergia.wordpress.com/2011/02/28/using-powershell-and-smo-to-script-sql-server-database-objects-3/u" rel="ugc">http://philergia.wordpress.com/2011/02/28/using-powershell-and-smo-to-script-sql-server-database-objects-3/u</a>
</div>


I can write code for you, but it might take time. you can read the article below and help yourself -

http://philergia.wordpress.com/2011/02/28/using-powershell-and-smo-to-script-sql-server-database-objects-3/u [http://philergia.wordpress.com/2011/02/28/using-powershell-and-smo-to-script-sql-server-database-objects-3/u]

<div>
Thanks folks. Now I have enough information to start with my solutions, probably powershell + SMO. It would be even better if SMO has a Java interface.
</div>


Thanks folks. Now I have enough information to start with my solutions, probably powershell + SMO. It would be even better if SMO has a Java interface.

<div>
<div class="content wysiwyg-content">
I need a mechanism which could be executed in a script (either Windows or UNIX) to generate the DDLs of re-creating all DB objects (tables, views, stored procedures etc.) in a given SQL Server 2008 database.<br />
<br />
Any suggestion?<br />

</div>
</div>


I need a mechanism which could be executed in a script (either Windows or UNIX) to generate the DDLs of re-creating all DB objects (tables, views, stored procedures etc.) in a given SQL Server 2008 database.

Any suggestion?


How to reverse-engineer the DDLs of all database objects with a script?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.