Solved

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

Posted on 2009-07-15
2
232 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Bit flags and bit flag manipulation is perhaps one of the most underrated strategies in programming, likely because most programmers developing in high-level languages rely too much on the high-level features, and forget about the low-level ones. Th…
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…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now