private static string GetSQL(DatabaseInfo.VersionTypeEnum version, SqlOption options) { string sql = ""; sql += "SELECT T.object_id, O.type AS ObjectType, ISNULL(CONVERT(varchar,AM.execute_as_principal_id),'CALLER') as ExecuteAs, AF.name AS assembly_name, AM.assembly_class, AM.assembly_id, AM.assembly_method, T.type, CAST(ISNULL(tei.object_id,0) AS bit) AS IsInsert, CAST(ISNULL(teu.object_id,0) AS bit) AS IsUpdate, CAST(ISNULL(ted.object_id,0) AS bit) AS IsDelete, T.parent_id, S.name AS Owner,T.name,is_disabled,is_not_for_replication,is_instead_of_trigger "; sql += "FROM sys.triggers T "; sql += "INNER JOIN sys.objects O ON O.object_id = T.parent_id "; sql += "INNER JOIN sys.schemas S ON S.schema_id = O.schema_id "; sql += "LEFT JOIN sys.trigger_events AS tei ON tei.object_id = T.object_id and tei.type=1 "; sql += "LEFT JOIN sys.trigger_events AS teu ON teu.object_id = T.object_id and teu.type=2 "; sql += "LEFT JOIN sys.trigger_events AS ted ON ted.object_id = T.object_id and ted.type=3 "; if (version == DatabaseInfo.VersionTypeEnum.SQLServerAzure10) { sql += ",(SELECT null as execute_as_principal_id, null as assembly_class, null as assembly_id, null as assembly_method) AS AM,"; sql += "(SELECT null AS name) AS AF"; } else { sql += "LEFT JOIN sys.assembly_modules AM ON AM.object_id = T.object_id "; sql += "LEFT JOIN sys.assemblies AF ON AF.assembly_id = AM.assembly_id"; } sql += " ORDER BY T.parent_id"; return(sql); }
public static string GetCheck(DatabaseInfo.VersionTypeEnum version) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2005) { return(GetCheck2005()); } //Fall back to highest compatible version return(GetCheck2008()); }
public static string GetView(DatabaseInfo.VersionTypeEnum version) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2000 || version == DatabaseInfo.VersionTypeEnum.SQLServer2005 || version == DatabaseInfo.VersionTypeEnum.SQLServer2008 || version == DatabaseInfo.VersionTypeEnum.SQLServer2008R2) return GetViewSql2008(); //Fall back to highest compatible version return GetViewSqlAzure(); }
public static string GetTableCount(DatabaseInfo.VersionTypeEnum version) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2000) { return(GetTableCount2000()); } //Fall back to highest compatible version return(GetTableCount2005()); }
private static string GetSQL(DatabaseInfo.VersionTypeEnum version, SqlOption options) { if (version == DatabaseInfo.VersionTypeEnum.SQLServerAzure10) { return(SQLQueries.SQLQueryFactory.Get("DBDiff.Schema.SQLServer.Generates.SQLQueries.GetTriggers", version)); } else { return(SQLQueries.SQLQueryFactory.Get("DBDiff.Schema.SQLServer.Generates.SQLQueries.GetTriggers")); } }
private static string GetSQL(DatabaseInfo.VersionTypeEnum version) { if (version == DatabaseInfo.VersionTypeEnum.SQLServerAzure10) { return(SQLQueries.SQLQueryFactory.Get("DBDiff.Schema.SQLServer.Generates.SQLQueries.GetProcedures", DatabaseInfo.VersionTypeEnum.SQLServerAzure10)); } else { return(SQLQueries.SQLQueryFactory.Get("DBDiff.Schema.SQLServer.Generates.SQLQueries.GetProcedures")); } }
public static string Get(DatabaseInfo.VersionTypeEnum version) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2005) { return(Get2005()); } if (version == DatabaseInfo.VersionTypeEnum.SQLServer2008) { return(Get2008()); } return(""); }
public static string Get(DatabaseInfo.VersionTypeEnum version) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2005 || version == DatabaseInfo.VersionTypeEnum.SQLServer2008 || version == DatabaseInfo.VersionTypeEnum.SQLServer2008R2) { return(Get2008()); } //fall back to highest compatible version return(GetAzure()); }
public static string GetUniqueKey(DatabaseInfo.VersionTypeEnum version) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2005) { return(GetUniqueKey2005()); } if (version == DatabaseInfo.VersionTypeEnum.SQLServer2008 || version == DatabaseInfo.VersionTypeEnum.SQLServer2008R2) { return(GetUniqueKey2008()); } //Fall back to highest compatible version return(GetUniqueKeyAzure()); }
public static string GetPrimaryKey(DatabaseInfo.VersionTypeEnum version, Table table) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2000) { return(GetPrimaryKey2000(table)); } if (version == DatabaseInfo.VersionTypeEnum.SQLServer2005) { return(GetPrimaryKey2005()); } if (version == DatabaseInfo.VersionTypeEnum.SQLServer2008) { return(GetPrimaryKey2008()); } return(""); }
private static string GetSQL(DatabaseInfo.VersionTypeEnum version) { string sql = ""; sql += "SELECT ISNULL(CONVERT(varchar,AM.execute_as_principal_id),'CALLER') as ExecuteAs, P.type, AF.name AS assembly_name, AM.assembly_class, AM.assembly_id, AM.assembly_method, P.object_id, S.name as owner, P.name as name "; sql += "FROM sys.procedures P "; sql += "INNER JOIN sys.schemas S ON S.schema_id = P.schema_id "; if (version == DatabaseInfo.VersionTypeEnum.SQLServerAzure10) { sql += ",(SELECT null as execute_as_principal_id, null as assembly_class, null as assembly_id, null as assembly_method) AS AM,"; sql += "(SELECT null AS name) AS AF"; } else { sql += "LEFT JOIN sys.assembly_modules AM ON AM.object_id = P.object_id "; sql += "LEFT JOIN sys.assemblies AF ON AF.assembly_id = AM.assembly_id"; } return sql; }
public static string GetTableDetail(DatabaseInfo.VersionTypeEnum version) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2000) { return(GetTableDetail2000()); } if (version == DatabaseInfo.VersionTypeEnum.SQLServer2005) { return(GetTableDetail2005()); } if (version == DatabaseInfo.VersionTypeEnum.SQLServer2008 || version == DatabaseInfo.VersionTypeEnum.SQLServer2008R2) { return(GetTableDetail2008()); } //Fall back to highest compatible version return(GetTableDetailAzure()); }
public static string Get(DatabaseInfo.VersionTypeEnum version, Database databaseSchema) { if (version == DatabaseInfo.VersionTypeEnum.SQLServer2005) { return(Get2005(databaseSchema)); } if (version == DatabaseInfo.VersionTypeEnum.SQLServer2008) { return(Get2008(databaseSchema)); } if (version == DatabaseInfo.VersionTypeEnum.SQLServer2008R2) { return(Get2008R2(databaseSchema)); } if (version == DatabaseInfo.VersionTypeEnum.SQLServerAzure10) { return(GetAzure(databaseSchema)); } return(""); }