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
Sounds a little interesting as well as a little scary. What version of SQL are you laying down, 2016 as a guess/hope?
Can you use SSMS to connect to it, guessing so?
Can you make backups from that data and restore those backups?
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.
Now are services like Reporting services an SSIS, SSAS available there as well?
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]
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
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]
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.
On 22 November 2016 at 21:04, Alan Bourke alanpbourke@fastmail.fm wrote:
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.
Could explain why I had to bump up my Hyper-V VM RAM to 3.5Gb! (Seems to use less in operation though)
On the plus side it is really fast to setup. It took me no time to setup an Ubuntu image, install SQL and get my app running.
I wonder how this will affect Azure sales?
So, this isn't really "SQL Server for Linux." THis is MS SQL Server running on an MS Windows OS in a VM where the host just happens to not be Windows. So, they can run Windows in a VM. Probably an advantage for Azure, but where's the big deal here? Is this going to be a licensing CAL break?
On Tue, Nov 22, 2016 at 4:18 PM, Paul Hill paulroberthill@gmail.com wrote:
On 22 November 2016 at 21:04, Alan Bourke alanpbourke@fastmail.fm wrote:
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.
Could explain why I had to bump up my Hyper-V VM RAM to 3.5Gb! (Seems to use less in operation though)
On the plus side it is really fast to setup. It took me no time to setup an Ubuntu image, install SQL and get my app running.
I wonder how this will affect Azure sales?
-- Paul
[excessive quoting removed by server]
On 2016-11-22 16:04, Alan Bourke wrote:
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.
So I'll ask it: how long until the Visual FoxPro apps run on Linux, given this advancement? Thought of this obvious question given the nature of this list, but also the hyperlink ("microsoft_running_windows_apps_on_linux")
-
Alan Bourke -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Paul Hill -
Stephen Russell -
Ted Roche