Esempio n. 1
0
        public void Install(string masterConnectionString, string newDatabaseName, string newDatabaseConnectionString)
        {
            SqlServers.CreateDatabase(masterConnectionString, newDatabaseName);
            DateTime startTime = DateTime.Now;

            while (DateTime.Now.Subtract(startTime).TotalSeconds < 9)
            {
                Application.DoEvents();
            }

            try
            {
                UpgradeInstaller.UpgradeDatabase(newDatabaseConnectionString, true);
            }
            catch (Exception ex)
            {
                System.Threading.Thread.Sleep(8000);
                try
                {
                    UpgradeInstaller.UpgradeDatabase(newDatabaseConnectionString, true);
                }
                catch
                {
                    throw;
                }
            }
        }
Esempio n. 2
0
        private void Initialize()
        {
            string dbVersion = SqlServers.GetDatabaseExtendedProperty(_connectionString, "dbVersion");

            if (dbVersion != string.Empty)
            {
                string[] versionNumbers = dbVersion.Split('.');
                _previousVersion          = new Version();
                _previousVersion.Major    = int.Parse(versionNumbers[0]);
                _previousVersion.Minor    = int.Parse(versionNumbers[1]);
                _previousVersion.Revision = int.Parse(versionNumbers[2]);
                _previousVersion.Build    = int.Parse(versionNumbers[3]);
            }
            Assembly assem = Assembly.GetExecutingAssembly();

            string[] resourceNames = assem.GetManifestResourceNames();
            foreach (string resourceName in resourceNames)
            {
                EmbeddedResourceName ern = new EmbeddedResourceName(resourceName);
                _resourceNames.Add(ern);
            }
        }
Esempio n. 3
0
 private void RunUpgrade()
 {
     _connection = new System.Data.SqlClient.SqlConnection(_connectionString);
     _connection.Open();
     _transaction = _connection.BeginTransaction();
     try
     {
         this.UpgradeSchemaAndStaticData();
         this.ReinstallStoredProcedures();
         _transaction.Commit();
         SqlServers.UpdateDatabaseExtendedProperty(_connectionString, "dbVersion", _upgradeToVersion.ToString("."));
         SqlServers.UpdateDatabaseExtendedProperty(_connectionString, "LastUpdate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture));
     }
     catch (Exception ex)
     {
         _transaction.Rollback();
         throw;
     }
     finally
     {
         _connection.Close();
     }
 }
Esempio n. 4
0
 private void ReinstallStoredProcedures()
 {
     try
     {
         SortedDictionary <string, EmbeddedResourceName> storedProcedures = this.GetResourceNameUnderLocation(".Stored_Procedures");
         foreach (EmbeddedResourceName ern in storedProcedures.Values)
         {
             try
             {
                 SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
             }
             catch (Exception ex)
             {
                 System.Windows.Forms.MessageBox.Show("Sp Fail: " + ern.FullName);
                 throw;
             }
         }
     }
     catch (Exception ex)
     {
         throw;
     }
 }
Esempio n. 5
0
        private void UpgradeSchemaAndStaticData()
        {
            const string CREATE_SCHEMA_FILE       = ".Create_Scripts.Generated.CreateSchema.sql";
            const string STATIC_DATA_FILE         = ".Create_Scripts.Generated.CreateData.sql";
            const string UPGRADE_FOLDER           = ".Upgrade_Scripts";
            const string UPGRADE_GENERATED_FOLDER = ".Upgrade_Scripts.Generated.";
            const string CREATE_FOLDER            = ".Cre ate_Scripts";

            try
            {
                SortedDictionary <string, EmbeddedResourceName> upgradeSchemaScripts = this.GetResourceNameUnderLocation(UPGRADE_GENERATED_FOLDER);
                SortedDictionary <string, EmbeddedResourceName> sortByVersionScripts = new SortedDictionary <string, EmbeddedResourceName>(upgradeSchemaScripts, new UpgradeFileNameComparer());

                //Run the generated upgrades
                if (!_previousVersion.Equals(_def_Version))
                {
                    foreach (EmbeddedResourceName ern in sortByVersionScripts.Values)
                    {
                        if (new Version(ern.FileName).CompareTo(_previousVersion) > 0)
                        {
                            SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
                        }
                    }
                }

                //Run the create schema
                SortedDictionary <string, EmbeddedResourceName> createSchemaScripts = this.GetResourceNameUnderLocation(CREATE_SCHEMA_FILE);
                foreach (EmbeddedResourceName ern in createSchemaScripts.Values)
                {
                    SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
                }

                //Run the static data
                createSchemaScripts = this.GetResourceNameUnderLocation(STATIC_DATA_FILE);
                foreach (EmbeddedResourceName ern in createSchemaScripts.Values)
                {
                    SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
                }

                //Run all other scripts
                SortedDictionary <string, EmbeddedResourceName> createDataScripts = this.GetResourceNameUnderLocation(CREATE_FOLDER);
                foreach (EmbeddedResourceName ern in createDataScripts.Values)
                {
                    //Make sure it is not the two defined scripts
                    if ((ern.AsmLocation != CREATE_SCHEMA_FILE) && (ern.AsmLocation != STATIC_DATA_FILE))
                    {
                        SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
                    }
                }

                //Run the user-defined upgrades
                List <string> excludePathList = new List <string>();
                excludePathList.Add(UPGRADE_GENERATED_FOLDER);
                upgradeSchemaScripts = this.GetResourceNameUnderLocation(UPGRADE_FOLDER, excludePathList);
                sortByVersionScripts = new SortedDictionary <string, EmbeddedResourceName>(upgradeSchemaScripts, new UpgradeFileNameComparer());
                if (_previousVersion != null)
                {
                    foreach (EmbeddedResourceName ern in sortByVersionScripts.Values)
                    {
                        if (new Version(ern.FileName).CompareTo(_previousVersion) > 0)
                        {
                            SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }