how to generate database script File in asp.net

Question

i have one Database i want Create Script File of this DataBase please Give Answer Thanks

Munesh Sharma · Answer

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)

Saber Shaikh · Answer

programmatically in C#

Munesh Sharma · Answer

https://technet.microsoft.com/en-us/library/ms178078(v=sql.105).aspx

Munesh Sharma · Answer

http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

Joginder Banger · Answer

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

how to generate database script File in asp.net

Answers (5)