Hello, I hope somebody in here can help me...
A while ago a link was posted on this forum. This link took you to a webpage where a comparison between different databases was made. A chart was also present. Ofcause Oracle was in top and SQL Server was close behind followed by PostgreSQL (I not 100% sure about PostgreSQL,though) but the next database was SQL Anywhere.
I tried looking for this comparision (also with the help of google) but because i do not remember more then I written I have not been successfull in finding it, please can somebody help me?
Thanks in advance
asked 11 Feb '16, 11:13
If you're working with small databases I've found running mysqldump on both databases with the --skip-comments and --skip-extended-insert options to generate SQL scripts, then running diff on the SQL scripts works pretty well.
By skipping comments you avoid meaningless differences such as the time you ran the mysqldump command. By using the --skip-extended-insert command you ensure each row is inserted with its own insert statement. This eliminates the situation where a single new or modified record can cause a chain reaction in all future insert statements. Running with these options produces larger dumps with no comments so this is probably not something you want to do in production use but for development it should be fine. I've put examples of the commands I use below:
mysqldump --skip-comments --skip-extended-insert -u root -p dbName1>file1.sql mysqldump --skip-comments --skip-extended-insert -u root -p dbName2>file2.sql diff file1.sql file2.sql
answered 01 Mar '16, 00:56
There are six commonly recognized models (types) of database that are useful for different types of data or information. Depending upon your specific needs, one of these models should be appropriate for your migration from paper based systems to a database.
Relational database Flat-file database Hierarchical & Network database Object-oriented database Object-relational database