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]