public static void CreateDatabaseSchema(string script) { try { DataAccessManager dam = new DataAccessManager(); SqlConnection conn = dam.GetConnection(); //conn.Close(); //conn.ConnectionString = conn.ConnectionString.Replace("EBusiness", "EBusiness_New"); //conn.Open(); //script = script.Replace("EBusiness", "EBusiness_New"); string[] commands = script.Split(new string[] { "GO\r\n", "\nGO\n", "Go", "Go\t" }, StringSplitOptions.RemoveEmptyEntries); foreach (string command in commands) { if (!command.Contains("[EBusiness]")) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = command; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } } MessageBox.Show("Schema Created successfully."); } catch (Exception ex) { throw; } }