Auto Creation of Databases

Some DBA's have very specific requirements to satisfy when creating a database. Some don't care and use the basic DEFAULT settings, and some configure the MODEL database to get it mostly correct by default.

Can we make this configurable such that Migrate can create the databases as needed, but allow a DBA to configure the required settings they need? Perhaps something as simple as just calling a MIGRATE.dbo.SYNCREATEDATABASE(@DBNAME) procedure. By default this would just create a database. But it can also be modified to do additional work like adding additional files, granting special permissions, etc. A stub to be extended by the DBA's based on their particular requirements.

Please authenticate to join the conversation.

Upvoters
Status

Future Consideration

Board

Syniti Knowledge Platform

Tags

Migrate

Date

Almost 3 years ago

Author

Subscribe to post

Get notified by email when there are changes.