Friday, June 16, 2017

Databases - The difference between MSSQL and MySQL

STEPS TO INSTALL SQL AND RESTORE DATA TO IT

MSSQL:-
* Download SQL Server 2016 (the free version presumably)
* Get message that SQL 2016 won't work on Windows 2008
* Install SQL Server 2008 (once you've found the correct link)
* Download MSSQL Management Studio (once you've found the correct link)
* Try and restore database backup
* Get message that backup was created with SQL Server v 10.5 and I am running 10.0.4
* Try and find out how to upgrade to SQL 10.5.
* Download SQL Server 2008 *R2*
* Try and restore database backup
* Still says version number is too low
* Uninstall SQL Server 2008 after assuming it would upgrade and not install side-by-side
* Try and restore database backup
* Profit!


Linux & MySQL:-
* sudo apt-get install mysql-server
* mysql --user me --passwordmypwd --database=mydatabase < datafile.sql

No comments: