5

I want to publish dac pac in single user mode to prevent unnecessary db changes while database is upgrading. For that I have used Deploy function in Microsoft.SqlServer.Dac.DacServices.

That function there is a argument DacDeployOptions options. I have set DeployDatabaseInSingleUserMode = true in that options. Even though it is set to true I am able to do db operation while dacpac is deploying.

Is there anything I am missing? or Is there any other way to achieve this.

Help will be Appreciated!

Chiragkumar Thakar
  • 3,616
  • 5
  • 37
  • 49
Suranga Bandara
  • 51
  • 3
  • 3
    I have see someone else with a similar problem - can you generate the script and see if it has an ALTER DATABASE SET SINGLE_USER ... near the top? – Ed Elliott Jul 08 '15 at 12:31

1 Answers1

0

Which version of DacFX are you using? If it's not the latest, best get the latest, because a lot of the older ones are not very good at recognizing the options you specify.

Alternatively, you could do this(It's what i've done, instead of trying to get DacFX to work properly.

            ServerConnection connection = new ServerConnection(ServerName);
            Server sqlServer = new Server(connection);
            Database QADatabase = sqlServer.Databases[DatabaseName];
            QADatabase.DatabaseOptions.UserAccess = DatabaseUserAccess.Single;
            QADatabase.Alter(TerminationClause.RollbackTransactionsImmediately);
            QADatabase.Refresh();

//DACPAC logic goes here

            QADatabase.DatabaseOptions.UserAccess = DatabaseUserAccess.Multiple;
            QADatabase.Alter(TerminationClause.RollbackTransactionsImmediately);
            QADatabase.Refresh();
BeardOfTriumph
  • 71
  • 5