I'm looking for advice on migrating from SQL server to Postgres. Basically there will be a few areas to work on:
- Changing the database connector
- I will create the exact same database in Postgres with the equivalent tables/columns/index values
- update/insert queries will be stubbed to check that tables in both tables are exactly the same (we'll continue to work in parallel until we can pull all queries in a model and switch (as they should have been) depending on which database we're currently using, but we'll avoid that until it's absolutely necessary).
- result sets from queries will be compared from both databases to detect differences there
So that's our plan for now. Other ideas please?