Exemple #1
0
        public static string TableSchemaDifference(CompareSideType sideType, TableName tableName1, TableName tableName2)
        {
            string sql;

            if (tableName2.Exists())
            {
                TableSchemaCompare compare = new TableSchemaCompare(tableName1, tableName2)
                {
                    SideType = sideType
                };
                sql = compare.Compare();
            }
            else
            {
                sql = tableName1.GenerateCreateTableClause(appendGO: true);
            }

            return(sql);
        }
Exemple #2
0
        public static string TableSchemaDifference(CompareSideType sideType, TableName tableName1, TableName tableName2)
        {
            string sql;

            if (tableName2.Exists())
            {
                TableSchemaCompare compare = new TableSchemaCompare(tableName1, tableName2) { SideType = sideType };
                sql = compare.Compare();
            }
            else
            {
                sql = tableName1.GenerateCluase();
            }

            return sql;
        }