Here is a good overview of MSSQL on Linux. Basically it's running in a Windows container. A Windows 8 kernel running on its Drawbridge container platform, which in turn is a native Linux daemon I guess.
http://www.theregister.co.uk/2016/11/18/microsoft_running_windows_apps_on_linux/ As it stands it is just the database engine - the tools and BI stuff is supposedly coming later. I would guess it is the full fat engine. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Tue, 22 Nov 2016, at 05:35 PM, Stephen Russell wrote: > Thanks. Wonder if this is only a SQL Express version to start. I wonder > if my SMO code would run from your desktop to the API to do things if > they > are greyed out in the SSMS? You could do the same thing in VFP if you > were > bored for the afternoon and create an object on SMO and then started to > press its buttons from your own form. > > you will have to generate a server object Also generate the Database, db, > object as well. > Server stageServer = GeneralWork.setServer("Servername\\Instance", > "user", > "pw_here"); > > String sql = "SELECT sdb.Name AS DatabaseName, > COALESCE(CONVERT(VARCHAR(12), MAX(bus.backup_finish_date), 101),'-') AS > LastBackUpTime > FROM sys.sysdatabases sdb > LEFT OUTER JOIN msdb.dbo.backupset bus ON bus.database_name = sdb.name > GROUP BY sdb.Name > > try > { // now get the resulst back from any query this way > DataSet ds = db.ExecuteWithResults(sql); // dataset kind > of equal to cursor > dgResult.DataSource = ds.Tables[0]; // set that > data > to somthing on your form > > > > > On Tue, Nov 22, 2016 at 11:02 AM, Paul Hill <[email protected]> > wrote: > > > 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 > > [excessive quoting removed by server] _______________________________________________ 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/1479848652.3732602.796279233.00902...@webmail.messagingengine.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.
