Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

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.SYN_CREATE_DATABASE(@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.

  • John Munkberg
  • Feb 23 2023
  • Attach files