예제 #1
0
        public MySmo.Database GetDatabase(Smo.Database smo_db, MySmo.Server parent = null)
        {
            #region implement

            var mysmo_db = new MySmo.Database();

            mysmo_db.ParentServer          = parent;
            mysmo_db.Name                  = smo_db.Name;
            mysmo_db.Owner                 = smo_db.Owner;
            mysmo_db.CreateTime            = smo_db.CreateDate;
            mysmo_db.ExtendedProperties    = GetExtendProperties(mysmo_db, smo_db.ExtendedProperties);
            mysmo_db.Schemas               = GetSchemas(smo_db, mysmo_db);
            mysmo_db.Tables                = GetTables(smo_db, mysmo_db);
            mysmo_db.Views                 = GetViews(smo_db, mysmo_db);
            mysmo_db.UserDefinedFunctions  = GetUserDefinedFunctions(smo_db, mysmo_db);
            mysmo_db.UserDefinedTableTypes = GetUserDefinedTableTypes(smo_db, mysmo_db);
            mysmo_db.StoredProcedures      = GetStoredProcedures(smo_db, mysmo_db);
            mysmo_db.CompatibilityLevel    = (MySmo.CompatibilityLevel)(int) smo_db.CompatibilityLevel;

            CombineExtendProperties(mysmo_db);

            return(mysmo_db);

            #endregion
        }
예제 #2
0
        public MySmo.Server GetServer(Oe.Server server)
        {
            #region implement

            var mysmo_server = new MySmo.Server();
            mysmo_server.Name      = _smo_server.InstanceName;
            mysmo_server.Databases = new List <MySmo.Database>();
            foreach (Smo.Database smo_db in _smo_server.Databases)
            {
                mysmo_server.Databases.Add(GetDatabase(smo_db, mysmo_server));
            }
            return(mysmo_server);

            #endregion
        }