22 Nov
2016
22 Nov
'16
9:04 p.m.
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_li...
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 paulroberthill@gmail.com
> wrote:
>
> > 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
> >
> > --
> > Paul
> >
[excessive quoting removed by server]