First impressions of installing and running SQL Server on a UNIX distribution (Ubuntu in this case) for a always-have-been-a-windows-use : better than a dream. You can have same one of the most loved and easy-to-use RDBMS SQL Server on a non-windows environment with no change in capabilities as far as OLTP workloads are considered. OLAP workloads do not map right now but i am sure Microsoft would be thinking of that as next logical step. Just so you know, almost everything that i tried works identically on Windows and Linux.
Installation and configuration was a breeze. You get a nice unix style console based configuration flow to choose the SKU ( i chose developer edition), configure SA password, select language etc.
Once it configured, it is already up and running. I was happy to notice that it running just fine on a 4 GB RAM, 2 V-CPU hyper-V VM.
How do you access it? Well there is no unix version of SQL Server management studio yet. So you have 2 options.
1. Use SQLCMD. It is not all that difficult to get used to.
2. Have a windows machine connect to your linux sql server through SSMS or Visual Studio :).
Installation and configuration was a breeze. You get a nice unix style console based configuration flow to choose the SKU ( i chose developer edition), configure SA password, select language etc.
Once it configured, it is already up and running. I was happy to notice that it running just fine on a 4 GB RAM, 2 V-CPU hyper-V VM.
How do you access it? Well there is no unix version of SQL Server management studio yet. So you have 2 options.
1. Use SQLCMD. It is not all that difficult to get used to.
2. Have a windows machine connect to your linux sql server through SSMS or Visual Studio :).
No comments:
Post a Comment