How do you manage databases in development, test, and production?

by

There are a couple of good options. I wouldn’t use the “restore a backup” strategy.

  1. Script all your schema changes, and have your CI server run those scripts on the database. Have a version table to keep track of the current database version, and only execute the scripts if they are for a newer version.

  2. Use a migration solution. These solutions vary by language, but for .NET I use Migrator.NET. This allows you to version your database and move up and down between versions. Your schema is specified in C# code.

More Related Contents:

  1. Create a Cumulative Sum Column in MySQL
  2. Equivalent of explode() to work with strings in MySQL
  3. 1064 error in CREATE TABLE … TYPE=MYISAM
  4. mysql select dynamic row values as column names, another column as value
  5. Access denied for user ‘root’@’localhost’ (using password: YES) (Mysql::Error)
  6. MySQL DELETE FROM with subquery as condition
  7. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  8. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  9. Simple Random Samples from a Sql database
  10. How to use LOAD_FILE to load a file into a MySQL blob?
  11. node.js mysql error: ECONNREFUSED
  12. Relational database design multiple user types
  13. Checking multiple columns for one value
  14. What is better in MYSQL count(*) or count(1)?
  15. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  16. Not unique table/alias
  17. How to enable INNODB in mysql
  18. MySQL GROUP BY DateTime +/- 3 seconds
  19. Calculate distance given 2 points, latitude and longitude [duplicate]
  20. Dynamic conversion of string into column name. MySQL
  21. How to write a (MySQL) “LIMIT” in SQL Server?
  22. How do I write an SP in phpMyAdmin (MySQL)?
  23. WooCommerce: Finding the products in database
  24. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  25. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  26. Mysql performance on 6 million row table
  27. How can I “select *” from a table in MySQL but omit certain columns?
  28. MySQL Select Multiple VALUES
  29. Convert SQL Server query to MySQL [duplicate]
  30. Dump only the data with mysqldump without any table information?

Leave a Comment