SMO Script Method

static void Main(string[] args)

{

Server srv = new Server("MyServer"); //Yukon
srv.ConnectionContext.LoginSecure = true;
srv.ConnectionContext.Connect();
srv.DefaultTextMode = false;

try

{
Database db = srv.Databases["customer"];
Transfer trans = new Transfer(db);
trans.Options.IncludeIfNotExists = true;
trans.CopyAllObjects = false;
trans.CopyAllLogins = true;

System.Collections.Specialized.StringCollection script = new StringCollection();

script = trans.ScriptTransfer();

foreach (String str in script)
{
Console.WriteLine("GO");
Console.WriteLine(str);
}
}

catch (Exception ex)

{

Console.WriteLine(ex);

}

PeterSaddowMSFT at 2007-10-6 >