On 22 November 2016 at 15:06, Stephen Russell srussell705@gmail.com wrote:
Sounds a little interesting as well as a little scary. What version of SQL are you laying down, 2016 as a guess/hope?
We use (IIRC) SQL 2008 as a minimum. We set the database compatibility level to max 2012 though. 2014 & 2016 changed the optimiser which resulted in *massive* speed problems for us.
Can you use SSMS to connect to it, guessing so?
Yes.
Can you make backups from that data and restore those backups?
No idea.
Does this support multiple instances and if so how to you restart an instance in Ununtu? It is a killer feature in Windows to be able to restart a specific instance.
No idea. Start/Stop are greyed out in SSMS BTW.
Now are services like Reporting services an SSIS, SSAS available there as well?
Mine does not have it, but maybe there are other install options.
This is something I am definitely going to keep an eye on!
Sorry for all the questions but overloaded in a migration job that is ending in a week or so.
On Tue, Nov 22, 2016 at 8:04 AM, Paul Hill paulroberthill@gmail.com wrote:
Hi All,
Just tried this on a Ubuntu VM. Got it up and running with no problems.
Our main C# app ran without changes. The database restore option failed (path/rights problem I think) but an import from our old version (DBFs) worked fine (this is quite a hefty process).
Not sure what the licensing etc will be. It will be interesting if they release an SQL Express version.
SQL Server vNext CTP1 on Ubuntu 16.04.: https://docs.microsoft.com/en-gb/sql/linux/sql-server-linux-setup-ubuntu