Manually with SQL ManagementStudio
Open or create new database
open scriptfile (*.sql) in query window
execute...
for C# code, example is:
string sqlString = string.Format("USE [master] CREATE DATABASE {0}", dbName);
SqlConnection conn = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand(sqlString, conn);
bool err = false;
try
{
conn.Open();
int r = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
created = "\nCreate database failed: " + ex.Message;
err = true;
}
conn.Close();
if (err) return created;
see codeproject link:
Deploy SQL Server databases easily with an Installer class[
^]
excerpt from link:
sr = new StreamReader("CreateTables.sql");
readsql = sr.ReadToEnd();
Regex regex = new Regex("^GO", RegexOptions.IgnoreCase | RegexOptions.Multiline);
string[] SqlLine = regex.Split(readsql);