public static void CheckAndUpgradeSchema(Session session)
        {
            DatabaseManagement dbm = new DatabaseManagement();

            DatabaseInformation.SQLState state = dbm.CheckDatabase();

            if (state == DatabaseInformation.SQLState.OMLDBNotFound) {
                //MessageBox.Show("Detected SQL Server but cannot find the database. Click OK to create the database.", "Databse problem", MessageBoxButtons.OK);
                // OML Instance but OML database does not exist
                dbm.ConfigureSQL(ScriptsPath);
                dbm.UpgradeSchemaVersion(ScriptsPath);

                // Retest the connection
                state = dbm.CheckDatabase();
            }

            if (state == DatabaseInformation.SQLState.OMLDBVersionUpgradeRequired) {
                //MessageBox.Show("Detected the OML Database but it requires updating. Click OK to update the database.", "Databse problem", MessageBoxButtons.OK);
                dbm.UpgradeSchemaVersion(ScriptsPath);

                // Retest the connection
                state = dbm.CheckDatabase();
            }

            if (state == DatabaseInformation.SQLState.OK) {
                //MessageBox.Show("The database appears all fine.", "Database status", MessageBoxButtons.OK);
                return;
            }
        }
Exemple #2
0
        public static void CheckAndUpgradeSchema(Session session)
        {
            DatabaseManagement dbm = new DatabaseManagement();

            DatabaseInformation.SQLState state = dbm.CheckDatabase();

            if (state == DatabaseInformation.SQLState.OMLDBNotFound)
            {
                //MessageBox.Show("Detected SQL Server but cannot find the database. Click OK to create the database.", "Databse problem", MessageBoxButtons.OK);
                // OML Instance but OML database does not exist
                dbm.ConfigureSQL(ScriptsPath);
                dbm.UpgradeSchemaVersion(ScriptsPath);

                // Retest the connection
                state = dbm.CheckDatabase();
            }

            if (state == DatabaseInformation.SQLState.OMLDBVersionUpgradeRequired)
            {
                //MessageBox.Show("Detected the OML Database but it requires updating. Click OK to update the database.", "Databse problem", MessageBoxButtons.OK);
                dbm.UpgradeSchemaVersion(ScriptsPath);

                // Retest the connection
                state = dbm.CheckDatabase();
            }

            if (state == DatabaseInformation.SQLState.OK)
            {
                //MessageBox.Show("The database appears all fine.", "Database status", MessageBoxButtons.OK);
                return;
            }
        }
 public static void ConfigureSQL(Session session)
 {
     DatabaseManagement dbm = new DatabaseManagement();
     dbm.ConfigureSQL(ScriptsPath);
 }
Exemple #4
0
        public static void ConfigureSQL(Session session)
        {
            DatabaseManagement dbm = new DatabaseManagement();

            dbm.ConfigureSQL(ScriptsPath);
        }