search

chucknorris / roundhouse

RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
http://projectroundhouse.org
917 stars 249 forks source link

Running RH without access to master database #442

Closed kimjamia closed 2 years ago

kimjamia commented 2 years ago

It would be really nice to have an option that prevents RH from trying to connect to the master database.

In Azure SQL Database, a user can run ALTER DATABASE commands if the user is a db_owner of the database. The user can be a contained database-authenticated user. The user doesn't need to be a master-database-authenticated login.

I worked around this by setting the --csa option to point to the same database but I'm not sure if that might cause some issues.

erikbra commented 2 years ago

Hi, @kimjamia . This shouldn't be a problem, I am pretty sure that it should not try to connect to the admin database if you specify the --dnc, aka --donotcreate switch. I have been using this specifically against Azure for that particular reason (see https://github.com/chucknorris/roundhouse/wiki/ConfigurationOptions#switches)

That said, please be aware that no one is actively maintaining RoundhousE at the moment, that I know of. I have called bankruptcy on the code, and started over, with grate, see #438 .