Solved

How do I run a sql script(text file) from a c# windows application using SQLDMO

Posted on 2009-07-15
2
241 Views
Last Modified: 2012-05-07
I am trying to create a 'Database Installer', that
a) Creates a database
b) runs a script from a text file

I used the code (in the code section)




I want to know how to run script from my text file(having the sql script)

// Assign a name to database
				nDatabase.Name = strDatabaseName;
				// Assign a name to datafile
				nDBFileData.Name = strDatabaseName;
				nDBFileData.PhysicalName = srv.Registry.SQLDataRoot + "\\DATA\\" + strDatabaseName + "_Data.mdf";
				nDBFileData.PrimaryFile = true;
				nDBFileData.Size = 2;
 
				nDBFileData.FileGrowthType = SQLDMO.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB;
				nDBFileData.FileGrowth = 1;
 
				//Add the DBFile object
				nDatabase.FileGroups.Item("PRIMARY").DBFiles.Add(nDBFileData);
 
				// Assign name to Log files
				nLogFile.Name = strDatabaseName + "Log";
				nLogFile.PhysicalName = srv.Registry.SQLDataRoot + "\\DATA\\" + strDatabaseName + "_Log.ldf";
				nLogFile.Size = 2;
				nDatabase.TransactionLog.LogFiles.Add(nLogFile);

Open in new window

0
Comment
Question by:vsoftsol
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 30

Accepted Solution

by:
Alexandre Simões earned 250 total points
ID: 24865661
Hi!

For that propose I usually use the SQLCMD tool:
http://msdn.microsoft.com/en-us/library/ms162773.aspx

Use the -i parameter to pass the input file path you want to execute.

If you don't know how to demand the execution of an exe from withing a C# application you can use the attached code.

Also add the SQLCMD.exe file to the same folder as your application.
System.Diagnostics.Process.Start("SQLCMD.exe", @"-U sa -P P@ssw0rd -S MyServer -i c:\myscript.sql");

Open in new window

0
 

Author Comment

by:vsoftsol
ID: 24877810
Thank you.Worked.
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question