public void TestSourceDataCopy()
{
//string dest = @"Data Source=FX026132M\SQLExpress;Initial Catalog=FGA_JMOINS1;Integrated Security=True;Connection Timeout=60";
//string dest = @"Data Source=FX027471M\SQLExpress;Initial Catalog=FGA_JMOINS1;Integrated Security=True;Connection Timeout=60";
//DBConnection d = new MSSQL2005_DBConnection(dest);
//SQLCopy.SQLUtils s = new SQLCopy.SQLUtils("ConnectionAdmin", dest);
DBConnectionDelegate s = new MSSQL2005_DBConnection("FGA_RW");
DBConnectionDelegate d = new MSSQL2005_DBConnection("FGA_JMOINS1");
bool bddVide = d.isDBEmpty();
if (bddVide)
{
DataSet ds = s.GetMetatDataDBScripts();
// sauvegarde des fichiers de scripts
TextFile.WriteTo(ds, "C:", "fga_db", "sql");
// on execute les scripts sur la base destination
DataTable schema = ds.Tables["SCHEMA"];
d.ExecuteScripts(schema);
DataTable table = ds.Tables["TABLE"];
d.ExecuteScripts(table);
DataTable fk = ds.Tables["FK"];
d.ExecuteScripts(fk);
DataTable procstock = ds.Tables["PROCSTOC"];
d.ExecuteScripts(procstock, useDBcmd: false);
}
else
{
Console.WriteLine("La base de donnée de destinaion n'est pas vide, opération annulée");
}
}
