C#

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Text; 
using Microsoft.SqlServer.Management.Smo; 
using System.Diagnostics; 
using System.Collections.Specialized; 

namespace Transfer2008To2005 
{ 
    class Program 
    { 
        static void Main(string[] args) 
        { 

            string sourceserver = "SourceServerName"; 
            string destinationserver = "DestinationServerName"; 

            Server src = new Server(sourceserver); 
            Server dest = new Server(destinationserver); 

            string[] myarray = new string[] { "databasename", "otherdbname" }; 

            foreach (Database db in src.Databases) 
            { 
                if (db.IsSystemObject == false && db.Status == DatabaseStatus.Normal) 
                { 
                    Debug.WriteLine("Now moving " + db.Name); 

                    if (dest.Databases.Contains(db.Name)) 
                        dest.KillDatabase(db.Name); 

                    Transfer t = new Transfer(db); 

                    t.DestinationServer = destinationserver; 
                    t.DestinationDatabase = db.Name; 
                    t.CreateTargetDatabase = true; 
                    t.PreserveDbo = true; 
                    t.TargetDatabaseFilePath = "D:\\SQLDATA\\"; 
                    t.TargetLogFilePath = "F:\\SQLLOGS\\"; 

                    t.CopyAllDefaults = true; 
                    t.CopyAllFullTextCatalogs = true; 
                    t.CopyAllRoles = true; 
                    t.CopyAllRules = true; 
                    t.CopyAllSchemas = true; 
                    t.CopyAllStoredProcedures = true; 
                    t.CopyAllSynonyms = true; 
                    t.CopyAllTables = true; 
                    t.CopyAllUserDefinedDataTypes = true; 
                    t.CopyAllUserDefinedFunctions = true; 
                    t.CopyAllUserDefinedTypes = true; 
                    t.CopyAllUsers = true; 
                    t.CopyData = true; 
                    t.CopySchema = true; 

                    t.CopyAllObjects = false; 
                    t.DropDestinationObjectsFirst = true; 

                    t.Options.WithDependencies = true; 
                    t.Options.IncludeDatabaseRoleMemberships = true; 
                    t.Options.Indexes = true; 
                    t.Options.DriAll = true; 
                    t.Options.Permissions = true; 
                    t.Options.SchemaQualify = true; 
                    t.Options.SchemaQualifyForeignKeysReferences = true; 
                    t.Options.Statistics = true; 
                    t.Options.TargetServerVersion = SqlServerVersion.Version90; 
                    t.Options.WithDependencies = true; 
                    t.Options.IncludeIfNotExists = true; 
                    t.Options.FullTextIndexes = true; 
                    t.Options.ExtendedProperties = true; 

                    t.TransferData(); 

                    t = new Transfer(db); 

                    t.DestinationServer = destinationserver; 
                    t.DestinationDatabase = db.Name; 
                    t.DestinationLogin = "schemalogin"; 
                    t.DestinationPassword = "schemapassword"; 
                    t.DestinationLoginSecure = false; 

                    t.CopyAllViews = true; 
                    t.CopyAllTables = true; 
                    t.CopyAllObjects = false; 
                    t.CopyAllDatabaseTriggers = true; 
                    t.Options.Triggers = true; 
                    t.CopyData = false; 
                    t.CopySchema = true; 
                    t.Options.IncludeIfNotExists = true; 

                    t.TransferData(); 
                } 
            } 
        } 
    } 
}