Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What point should someone decide to switch Database Systems

Tags:

sql

database

When developing whether its Web or Desktop at which point should a developer switch from SQLite, MySQL, MS SQL, etc

like image 822
Tanerax Avatar asked Aug 07 '08 16:08

Tanerax


1 Answers

It depends on what you are doing. You might switch if:

  • You need more scalability or better performance - say from SQLite to SQL Server or Oracle.
  • You need access to more specific datatypes.
  • You need to support a customer that only runs a particular database.
  • You need better DBA tools.
  • Your application is using a different platform where your database no longer runs, or it's libraries do not run.
  • You have the ability/time/budget to actually make the change. Depending on the situation, the migration could be a bigger project than everything in the project up to that point. Migrations like these are great places to introduce inconsistencies, or to lose data, so a lot of care is required.

There are many more reasons for switching and it all depends on your requirements and the attributes of the databases.

like image 130
Brian Lyttle Avatar answered Sep 28 '22 08:09

Brian Lyttle