/// <summary>
/// Compara el schema de la base con otro y devuelve el script SQL con las diferencias.
/// </summary>
/// <param name="xmlCompareSchema"></param>
/// <returns></returns>
public static Database Compare(Database databaseOriginalSchema, Database databaseCompareSchema)
{
Database merge = null;
merge = CompareDatabase.GenerateDiferences(databaseOriginalSchema, databaseCompareSchema);
return(merge);
}
/// <summary>
/// Compara el schema de la base con otro y devuelve el script SQL con las diferencias.
/// </summary>
/// <param name="xmlCompareSchema"></param>
/// <returns></returns>
public static Database Compare(Database databaseOriginalSchema, Database databaseCompareSchema)
{
Database merge;
CompareDatabase ftables = new CompareDatabase();
merge = ftables.GenerateDiferences(databaseOriginalSchema, databaseCompareSchema);
return(merge);
}
public void SaveDatabaseDiagramsInXml(bool pBool, string pDatabaseName)
{
SqlConnection connection = ConnectionManager.GeneralSqlConnection;
try
{
connection.Open();
CompareDatabase.SaveDatabaseDiagramsInXml(pBool, pDatabaseName, connection);
connection.Close();
}
catch (Exception)
{
connection.Close();
throw;
}
}
public string CheckSQLDatabaseSchema(string pDatabaseName)
{
SqlConnection connection = ConnectionManager.GeneralSqlConnection;
try
{
connection.Open();
bool same = false;
string additionnalColumn = string.Empty, missingColumn = string.Empty;
CompareDatabase.IsCurrentDatabaseIsRight(connection, pDatabaseName, ref same, ref additionnalColumn, ref missingColumn);
connection.Close();
return(same ? string.Empty : "{0}: \n" + additionnalColumn + "{1}: \n" + missingColumn);
}
catch (Exception)
{
connection.Close();
throw;
}
}
/// <summary>
/// Generates the differences to migrate a schema from origin to destination
/// </summary>
/// <param name="origin">The Origin schema is the schema before our generated actions are applied.</param>
/// <param name="destination">The Destination schema is the schema after our actions are applied.</param>
/// <returns></returns>
public static Database Compare(Database origin, Database destination)
{
Database merge = CompareDatabase.GenerateDifferences(origin, destination);
return(merge);
}
