Ignore error in executing SQL Script

Question

How can I make my code ignore the error while executing SQL Script file?

If there is an error while executing the sql script file, then I want this method to just ignore it and continue to run the sql script file. Currently, if I put try-catch block inside this method, the error gets caught as an exception and the execution of the SQL script file stops after the error has been caught. I want the execution to continue even if there is an error in the SQL Server.

How can I achieve this?

My code is below.

private void RunSQLScript()
{        
  // file is already defined as a SQL Script file

  string script = file.OpenText().ReadToEnd();

  SqlConnection conn = new SqlConnection(ConnectionString);

  // split script on GO command
  IEnumerable<string> commandStrings = Regex.Split(script, @"^\s*GO\s*$", RegexOptions.Multiline | RegexOptions.IgnoreCase);

  conn.Open();

  foreach (string commandString in commandStrings)
  {
    if (commandString.Trim() != "")
       {
          new SqlCommand(commandString, conn).ExecuteNonQuery();
       }
  }

  conn.Close();

}

dazedandconfused · Accepted Answer · 2013-05-28 15:04:42Z

2

Wrap the ExecuteNonQuery in a try/catch block and leave the catch block empty.

answered May 28, 2013 at 15:04

dazedandconfused

3,2162 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Butters Over a year ago

Thanks. Worked. Such a simple thing and I was putting try-catch on the entire method instead of just the ExecuteNonQuery part.

Collectives™ on Stack Overflow

Ignore error in executing SQL Script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related