Database Backup and restore in C# Windows Application

Hi,

In addition to Ger Hayden Solution, you must also
consider the Time out, cause backup sometimes take
too long.

Example code:

In your Web.config you have:

<add name="ClaimsORAConnection" connectionString="Provider=MSDAORA;Data Source=Your serverName;User ID=YourUserId;Password=YourPassword"/>

and then in your code behind:

OleDbCommand ocmd = new OleDbCommand();

string strConn = ConfigurationManager.ConnectionStrings["ClaimsORAConnection"].ConnectionString.ToString();
OleDbConnection aConn = new OleDbConnection((strConn + ";Connection Timeout=300; pooling='true';Max Pool Size=300"));

string strQry = "backup database databasename to disk ='C:\databasename.bak'"
try
{
   ocmd.CommandTimeout = 300;
   ocmd = new System.Data.OleDb.OleDbCommand(strQry, aConn);
   ocmd.ExecuteNonQuery();
}
catch (Exception)
{
    return "Backup process failed...";
}
finally
{
   ocmd.Dispose();
   aConn.Close();
}

The Connection Timeout should be fair with Command Timeout otherwise
process catch Timeout.

You may adjust the Time out duration from 300 or more,
depending in time of process


Please remember to mark the replies as answers if they help and unmark them if they provide no help.


Hope this could help.


Regards,

Algem

try using the class I posted here http://g4ac.co.za/RjwyM[^]

You don't need the source code - use the documentation that came with each database to find the specific command for export / dump e.g. mysqldump and string it into something like cmd.CommandText then execute it with something line cmd.ExecuteScalar(), where cmd is defined as

Sql cmd = new SqlCommand

.

Repeat for each database.

There are also more crude work arounds that you can do in code like select * from each table and hold the result in a csv file.

Hi,

ClaimsORAConnection is an oracle connection string defination in config file

<add name="ClaimsORAConnection" connectionString="Provider=MSDAORA;Data Source=Your serverName;User ID=YourUserId;Password=YourPassword"/>

ClaimsORAConnection is a connection defined in your config.
<connectionStrings>
   <!-- it should be here -->
</connectionStrings>