public void ImportExtendedProperties(DatabaseExtendedProperties dep)
{
double t = 0;
SqlDatabase.Refresh();
double total = dep.Tables.Count;
// bool DoAlter = UpdateExtendedProperties(SqlDatabase.ExtendedProperties,)
RaiseUpdateEvent(0, "Database level extended properties extported");
foreach (Microsoft.SqlServer.Management.Smo.Table table in SqlDatabase.Tables)
{
TableExtendedProperties tep = dep.Tables.FirstOrDefault(x => x.Name.Equals(table.Name, StringComparison.OrdinalIgnoreCase) && x.Schema.Equals(table.Schema, StringComparison.OrdinalIgnoreCase));
if (tep != null)
{
table.Refresh();
bool alter = UpdateExtendedProperties(table.ExtendedProperties, tep);
if (tep.Columns.Count > 0)
{
foreach (Column column in table.Columns)
{
SqlExtendedPropertyContainer cep = tep.Columns.FirstOrDefault(x => x.Name.Equals(column.Name));
if (cep != null)
{
if (UpdateExtendedProperties(column.ExtendedProperties, cep))
{
column.Alter();
}
}
}
}
if (alter)
{
table.Alter();
}
t++;
RaiseUpdateEvent(Convert.ToInt32((t / total) * 100), table.Schema + "." + table.Name + " extended properties imported");
}
}
}
public DatabaseExtendedProperties ExportExtendedProperties()
{
DatabaseExtendedProperties dep = new DatabaseExtendedProperties();
double t = 0;
SqlDatabase.Refresh();
double total = SqlDatabase.Tables.Count;
RetrieveExtendedProperties(SqlDatabase.ExtendedProperties, dep);
RaiseUpdateEvent(0, "Database level extended properties extported");
foreach (Microsoft.SqlServer.Management.Smo.Table table in SqlDatabase.Tables)
{
table.Refresh();
TableExtendedProperties tep = new TableExtendedProperties();
RetrieveExtendedProperties(table.ExtendedProperties, tep);
tep.Schema = table.Schema;
tep.Name = table.Schema;
foreach (Column column in table.Columns)
{
SqlExtendedPropertyContainer cep = new SqlExtendedPropertyContainer();
RetrieveExtendedProperties(column.ExtendedProperties, cep);
if (cep.Properties.Count > 0)
{
cep.Schema = column.DefaultSchema;
cep.Name = column.Name;
tep.Columns.Add(cep);
}
}
if (tep.Properties.Count > 0 || tep.Columns.Count > 0)
{
dep.Tables.Add(tep);
}
t++;
RaiseUpdateEvent(Convert.ToInt32((t / total) * 100), table.Schema + "." + table.Name + " extended properties exported");
}
return(dep);
}
public DatabaseExtendedProperties ExportExtendedProperties()
{
DatabaseExtendedProperties dep = new DatabaseExtendedProperties();
double t = 0;
SqlDatabase.Refresh();
double total = SqlDatabase.Tables.Count;
RetrieveExtendedProperties(SqlDatabase.ExtendedProperties, dep);
RaiseUpdateEvent(0, "Database level extended properties extported");
foreach (Microsoft.SqlServer.Management.Smo.Table table in SqlDatabase.Tables)
{
table.Refresh();
TableExtendedProperties tep = new TableExtendedProperties();
RetrieveExtendedProperties(table.ExtendedProperties, tep);
tep.Schema = table.Schema;
tep.Name = table.Schema;
foreach (Column column in table.Columns)
{
SqlExtendedPropertyContainer cep = new SqlExtendedPropertyContainer();
RetrieveExtendedProperties(column.ExtendedProperties, cep);
if (cep.Properties.Count > 0)
{
cep.Schema = column.DefaultSchema;
cep.Name = column.Name;
tep.Columns.Add(cep);
}
}
if (tep.Properties.Count > 0 || tep.Columns.Count > 0)
{
dep.Tables.Add(tep);
}
t++;
RaiseUpdateEvent(Convert.ToInt32((t / total) * 100), table.Schema + "." + table.Name + " extended properties exported");
}
return dep;
}
public void ImportExtendedProperties(DatabaseExtendedProperties dep)
{
double t = 0;
SqlDatabase.Refresh();
double total = dep.Tables.Count;
// bool DoAlter = UpdateExtendedProperties(SqlDatabase.ExtendedProperties,)
RaiseUpdateEvent(0, "Database level extended properties extported");
foreach (Microsoft.SqlServer.Management.Smo.Table table in SqlDatabase.Tables)
{
TableExtendedProperties tep = dep.Tables.FirstOrDefault(x => x.Name.Equals(table.Name, StringComparison.OrdinalIgnoreCase) && x.Schema.Equals(table.Schema, StringComparison.OrdinalIgnoreCase));
if (tep != null)
{
table.Refresh();
bool alter = UpdateExtendedProperties(table.ExtendedProperties, tep);
if (tep.Columns.Count > 0)
{
foreach (Column column in table.Columns)
{
SqlExtendedPropertyContainer cep = tep.Columns.FirstOrDefault(x => x.Name.Equals(column.Name));
if (cep != null)
{
if (UpdateExtendedProperties(column.ExtendedProperties, cep))
{
column.Alter();
}
}
}
}
if (alter)
{
table.Alter();
}
t++;
RaiseUpdateEvent(Convert.ToInt32((t / total) * 100), table.Schema + "." + table.Name + " extended properties imported");
}
}
}