private async Task <string[]> CompareSchemasAsync(JMXSchema schema, JMXSchema fromDbSchema)
{
List <string> sql = new List <string>();
using (SQLStatementWriter sb = new SQLStatementWriter(SqlServerHelper.TypeMapping, schema))
{
await CompareSchemasStatementsAsync(sb, schema, fromDbSchema);
string stmt = sb.ToString();
if (stmt.Length > 1)
{
sql.Add(sb.ToString());
}
}
return(sql.ToArray());
}
private static string[] CreateNewStatements(JMXSchema schema)
{
List <string> sql = new List <string>();
using (SQLStatementWriter sb = new SQLStatementWriter(SqlServerHelper.TypeMapping, schema))
{
sb.WriteCreateNewTableStatements();
sql.Add(sb.ToString());
}
return(sql.ToArray());
}
private async Task <string[]> DropSchemaStatementsAsync(JMXSchema fromDbSchema)
{
List <string> sql = new List <string>();
using (SQLStatementWriter sb = new SQLStatementWriter(SqlServerHelper.TypeMapping, fromDbSchema))
{
await WriteDropStatementsAsync(sb, fromDbSchema);
sql.Add(sb.ToString());
}
return(sql.ToArray());
}