If I find out that I've got something wrong, I'll fix it.I am comparing the two databases from the point of view of a data analyst.
Maybe MS SQL Server kicks Postgre SQL's arse as an OLTP backend (although I doubt it), but that's not what I'm writing about here, because I'm not an OLTP developer/DBA/sysadmin. Do please use it if you wish; I will do my best to respond. This section is a comparison of the two databases in terms of features relevant to data analytics.CSV is the de facto standard way of moving structured (i.e. All RDBMSes can dump data into proprietary formats that nothing else can read, which is fine for backups, replication and the like, but no use at all for migrating data from system X to system Y.“I'm anxious to get SQL Source Control up and running as I know the only way to deliver high quality SQL code is by having it under a SCM tool, vigorously testing, (thank you for SQL Test) and being able to confidently and consistently build/deploy the code.There is so much that Redgate is doing to make Agile Database Development a reality.Still very much beginning this project, but please let me know if you find it useful or have any feature requests.
This page is being retained for reference purposes only.
SQL Compare writes deployment scripts in minutes, making your release safe and efficient.
You can deploy from SQL Compare or copy the script to review and run later.
I work as a data analyst in a global professional services firm (one you have certainly heard of). I have spent that decade dealing with data, database software, database hardware, database users, database programmers and data analysis methods, so I know a fair bit about these things.
I frequently come into contact with people who know very little about these things – although some of them don't realise it. This document is my way of automating that conversation.
I know it's not scientifically rigorous to do a comparison like this when I don't have equal experience with both databases, but this is not an academic exercise – it's a real-world comparison.