InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 17:14:11 GMT20http://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxi will look into this Thank you so much for your time Wed, 23 Jan 2013 02:19:13 GMTgetsimrangujralhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxWell then you will need to write a command line based application which interfaces with SQL SMO and script out your database to a file.As detailed, do a search for "Script Database via Command Line" and you will find help on what you want to do.Wed, 23 Jan 2013 02:12:32 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxexport the database to a file called c:\script.sql which contains all the schemas and datai want to do thisWed, 23 Jan 2013 02:10:00 GMTgetsimrangujralhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxDo you have a script in the location c:\script.sql which contains the database schema and data to create a new copy of the CZ database?OrDo you want to export the CZ database to a file called c:\script.sql which contains all the schemas and data?Wed, 23 Jan 2013 02:07:33 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxI just want to run this from command line , not by GUI mode ( cz database is too large )Wed, 23 Jan 2013 02:05:07 GMTgetsimrangujralhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxYes, but if you read the whole thing, you will see that Pinal Dave has run the SSMS GUI tool, saved the file as c:\script.sql and is then using the command line to run the script to create the objects and import the data.What are you trying to do?Have you run the GUI and exported the schema and the data into a file?Wed, 23 Jan 2013 01:55:46 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxhttp://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/look at the end part ( there is a command for large table )Wed, 23 Jan 2013 01:50:37 GMTgetsimrangujralhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxThey you need to look at writing a command line program which interfaces with the SQL SMO objects to pull out the DDL of the database.Wed, 23 Jan 2013 01:47:08 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxYes i can do with ssms , but the problem is database too large , soo it throw me error Thank youWed, 23 Jan 2013 01:45:35 GMTgetsimrangujralhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspx-i is an input file which means you want to use that file to run it against the DB, not that you want to script out the DB to the file.Do a google search (other search engines avilable) for "Script Database Via Command Line" you will get many hits.Also remember that SQL has a built in GUI in SSMS which will do this for you.Wed, 23 Jan 2013 01:28:32 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxcommand line generate script for database ?Tue, 22 Jan 2013 21:58:30 GMTgetsimrangujralhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxWhat is the error messageTue, 22 Jan 2013 05:52:44 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxit is not workingTue, 22 Jan 2013 05:51:22 GMTgetsimrangujralhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspx[quote][b]getsimrangujral (1/21/2013)[/b][hr]C:\Users\1245>sqlcmd -S MOLNEW0014\TEST -i c:\script.sqlSqlcmd: 'c:\script.sql': [b]Invalid filename[/b].[/quote]Invalid filename, correct the filename and re-tryTue, 22 Jan 2013 01:20:51 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409789-391-1.aspxC:\Users\1245>sqlcmd -S MOLNEW0014\TEST -i c:\script.sqlSqlcmd: 'c:\script.sql': Invalid filename.Mon, 21 Jan 2013 23:09:10 GMTgetsimrangujral