public void CanScriptOutAlevinDatabase()
        {
            try
            {
                var testSubject = new DatabaseBackupViaSqlFileCreator(DatabaseServer, "AlevinDB");

                // Act
                // ---
                string sqlBackup = testSubject.CreateSqlBackup();

                // Assert
                // ------
                Approvals.Verify(sqlBackup);
            }
            finally
            {
            }
        }
        public void CanScriptOutDatabase()
        {
            // Arrange
            // -------
            using (var initialConn = new SqlConnection(string.Format("Server={0};Database={1};Trusted_Connection=True;pooling=false", DatabaseServer, DefaultStartDatabase)))
            {
                initialConn.Open();
                CleanupDatabase(initialConn);
                SetupTestDatabase(initialConn);
                initialConn.Close();
            }

            try
            {
                var testSubject = new DatabaseBackupViaSqlFileCreator(DatabaseServer, _testDatabaseName);

                // Act
                // ---
                string sqlBackup = testSubject.CreateSqlBackup();

                // Assert
                // ------
                Approvals.Verify(sqlBackup);
            }
            finally
            {
                using (var secondConn = new SqlConnection(string.Format("Server={0};Database={1};Trusted_Connection=True;pooling=false", DatabaseServer, DefaultStartDatabase)))
                {
                    secondConn.Open();
                    // Clean up
                    // ---------
                    CleanupDatabase(secondConn);
                    secondConn.Close();
                }
            }
        }