public static bool FilterTypes(Urn urn)
{
if (urn.Type == "UserDefinedDataType")
{
TraceService.Debug("Filtered UserDefinedDataType");
return(true);
}
if (urn.Type == "XmlSchemaCollection")
{
TraceService.Debug("Filtered XmlSchemaCollection");
return(true);
}
if (urn.Type == "StoredProcedure")
{
TraceService.Debug("Filtered StoredProcedure");
return(true);
}
if (urn.Type == "UnresolvedEntity")
{
TraceService.Debug("Filtered UnresolvedEntity");
return(true);
}
return(false);
}
private List <Urn> GetGenericUrns(SmoCollectionBase collections)
{
var urns = new List <Urn>();
foreach (SqlSmoObject smo in collections)
{
//skip all system objects
if (smo is Schema && ((smo as Schema).IsSystemObject))
{
continue;
}
if (smo is Table && ((smo as Table).IsSystemObject))
{
continue;
}
if (smo is View && ((smo as View).IsSystemObject))
{
continue;
}
if (smo is StoredProcedure && ((smo as StoredProcedure).IsSystemObject))
{
continue;
}
if (smo is UserDefinedFunction && ((smo as UserDefinedFunction).IsSystemObject))
{
continue;
}
TraceService.Debug($"Listed urn for scripting: {smo.Urn}");
urns.Add(smo.Urn);
}
return(urns);
}