public void executeScriptOnDestinationServer(string script) { try{ using (SqlConnection serverConnection = new SqlConnection(destination)){ SqlCommand cmd = new SqlCommand(script, serverConnection); Console.WriteLine("Executing script: " + script); DataUtilLibrary.writeToLog("Executing script: " + script + " on source database."); cmd.CommandTimeout = 0; serverConnection.Open(); cmd.ExecuteNonQuery(); } }catch (Exception e) { DataUtilLibrary.writeToLog("Error while running script: " + e.Message); DataUtilLibrary.writeToLog(e.StackTrace); } }
public bool initSourceConnectionString() { bool canConnect = false; try { sourceConnectionString = @"Network Library=DBMSSOCN;Data Source=" + sourceServer + "," + sourcePort + ";database=" + sourceDatabase + ";User id=officeadmin;Password=AdminOfficer123;Connection Timeout=0;Pooling=false;Packet Size=16384;"; SqlConnection serverConnection = new SqlConnection(sourceConnectionString); serverConnection.Open(); canConnect = true; serverConnection.Close(); }catch (Exception e) { DataUtilLibrary.writeToLog("Error connecting to server: " + e.Message); DataUtilLibrary.writeToLog(e.StackTrace); } return(canConnect); }
public bool initDestinationConnectionString() { bool canConnect = false; try { destinationConnectionString = @"Network Library=DBMSSOCN;Data Source=" + destinationServer + "," + destinationPort + ";database=" + destinationDatabase + ";Trusted_Connection=True;Connection Timeout=0;Pooling=false;Packet Size=16384;"; SqlConnection serverConnection = new SqlConnection(destinationConnectionString); serverConnection.Open(); canConnect = true; serverConnection.Close(); }catch (Exception e) { DataUtilLibrary.writeToLog("Error while running script: " + e.Message); DataUtilLibrary.writeToLog(e.StackTrace); } return(canConnect); }
public System.Data.DataTable getDataFromDestinationDatabase(string script) { System.Data.DataTable dt = new DataTable(); try{ using (SqlConnection serverConnection = new SqlConnection(destinationConnectionString)){ SqlCommand cmd = new SqlCommand(script, serverConnection); DataUtilLibrary.writeToLog("Executing script: " + script + " on destination database."); cmd.CommandTimeout = 0; serverConnection.Open(); SqlDataReader reader = cmd.ExecuteReader(); dt.Load(reader); cmd.Dispose(); } }catch (Exception e) { DataUtilLibrary.writeToLog("Error while running script: " + e.Message); DataUtilLibrary.writeToLog(e.StackTrace); } return(dt); }