On 22 November 2016 at 15:06, Stephen Russell <[email protected]> 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 <[email protected]> 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 -- Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cadwx0+jczd53se+jsf2yni7nbjevs7-5s2dv3hn9-605zf5...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
