private ServerNode SetupServerNodeWithCreator(SmoWrapper creator)
{
ServerNode node = new ServerNode(defaultConnParams, ServiceProvider, new ServerConnection(new SqlConnection(fakeConnectionString)));
node.SmoWrapper = creator;
return(node);
}
private ServerNode SetupServerNodeWithCreator(SmoWrapper creator)
{
ServerNode node = new ServerNode(defaultConnParams, ServiceProvider);
node.SmoWrapper = creator;
return(node);
}
/// <summary>
/// Saves all objects in database as *.sql scripts in subdirectories
/// organized by object type.
/// </summary>
/// <param name="basePath">Base directory to save scripts to.</param>
/// <param name="label">Label of subfolder.</param>
/// <param name="collection">Collection of SMOs to save.</param>
/// <param name="extendedSave">Optional custom save delegate (if not null, callee is completely responsible for saving.)</param>
protected void SaveObjects(String basePath, String label,
SmoCollectionBase collection, SaveAllowedDelegate saveAllowed)
{
String folder = Path.Combine(basePath, label);
if (!Directory.Exists(folder))
Directory.CreateDirectory(folder);
foreach (SqlSmoObject obj in collection)
{
SmoWrapper wrapper = new SmoWrapper(obj);
if (wrapper.IsSystemObject)
continue;
if (saveAllowed == null || (saveAllowed != null && saveAllowed(wrapper)))
{
using (ScriptWriter scriptWriter = new ScriptWriter(
new StreamWriter(
Path.Combine(folder, String.Format("{0}.sql",
StringUtils.NormalizeFilename(
wrapper.QualifiedName)))), _options))
{
scriptWriter.WriteDefinition(wrapper);
}
}
}
}
protected void SaveCachedObject(String basePath, ObjectCache.CachedObject cachedObj)
{
Server server = new Server(_server.Name);
InitServer(server);
Database database = server.Databases[_database.Name];
String folder = Path.Combine(basePath, cachedObj.Label);
if (!Directory.Exists(folder))
Directory.CreateDirectory(folder);
SqlSmoObject obj = cachedObj.Activate(database);
SmoWrapper wrapper = new SmoWrapper(obj);
if (wrapper.IsSystemObject)
return;
using (ScriptWriter scriptWriter = new ScriptWriter(
new StreamWriter(
Path.Combine(folder, String.Format("{0}.sql",
StringUtils.NormalizeFilename(
wrapper.QualifiedName)))), _options))
{
scriptWriter.WriteDefinition(wrapper);
}
}
/// <summary>
///
/// </summary>
/// <param name="wrapper"></param>
public void WriteDefinition(SmoWrapper wrapper)
{
Console.WriteLine("[{0}] {1}", wrapper.SmoObject.GetType().Name, wrapper.QualifiedName);
WriteDefinition((IScriptable)wrapper.SmoObject);
}
/// <summary>
///
/// </summary>
/// <param name="wrapper"></param>
public void WriteExtendedProperties(SmoWrapper wrapper)
{
ExtendedPropertyCollection extendedProperties = wrapper.ExtendedProperties;
if (extendedProperties != null && extendedProperties.Count > 0)
{
WriteBlockTitle("Extended Properties");
foreach (ExtendedProperty prop in extendedProperties)
WriteDefinition(prop);
}
}
