how to generate database script File in asp.net

http://www.codeproject.com/Articles/20396/Sql-Script-Generator-in-C-From-SQL-Table


Here is an example for Generating Database Script by using visual studio 2010:
The first step is to add the project references to the SMO DLL's. These can be found in the C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies directory. You'll need to add references to the following DLL's:
• Microsoft.SqlServer.ConnectionInfo.dll •

Microsoft.SqlServer.Smo.dll •

Microsoft.SqlServer.SmoEnum.dll

Then add this reference:
using Microsoft.SqlServer.Management.Common;

using Microsoft.SqlServer.Management.Smo;

using System.Collections.Specialized;

using Microsoft.SqlServer.Management.Sdk.Sfc;

Now you could test below code in the Page_Load() function:
protected void Page_Load(object sender, EventArgs e)

{ Server myServer = new Server("YouSQLServerName");

Scripter scripter = new Scripter(myServer);

Database myAdventureWorks = myServer.Databases["YourDatabaseName"];

Urn[] DatabaseURNs = new Urn[] { myAdventureWorks.Urn}; StringCollection scriptCollection = scripter.Script(DatabaseURNs);

foreach (string script in scriptCollection)

{ Response.Write(script);

Response.Write("
"); } }

For further information, you could access to the below link:
http://www.mssqltips.com/sqlservertip/1833/generate-scripts-for-database-objects-with-smo-for-sql-server/
http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated
http://technet.microsoft.com/en-us/library/ms162153(v=sql.105)

what you think about this link
click here
and more link here