Page 1 of 1

SQL LocalDB Support

Posted: Mon Mar 12, 2012 6:31 am
by JohnGalt
I see the post and email regarding 2012 Express, but I don't see anything about the far superior and easier to install for Devs, LocalDB.

Is it supported? If not, when?

Should be able to specify instance, filestreaming enabled and what level, sql/integrated security and default sa password if sql security enabled via UI.

Thanks!

Re: SQL LocalDB Support

Posted: Thu May 31, 2012 7:47 am
by FrancescoT
Dear John,

Actually seems not possible.
Anyway I will check for it and I'll tell you.

Regards

Re: SQL LocalDB Support

Posted: Thu Nov 15, 2012 9:08 am
by erausner
So, what happened in regards to this thread?

Re: SQL LocalDB Support

Posted: Thu Nov 15, 2012 9:22 am
by FrancescoT
Dear User,

I can only confirm that it is not actually availble with IA.
I will log this as request to our dev team ... but no promises on delivery.

Regards

Re: SQL LocalDB Support

Posted: Thu Nov 15, 2012 9:25 am
by erausner
FrancescoT wrote:Dear User,

I can only confirm that it is not actually availble with IA.
I will log this as request to our dev team ... but no promises on delivery.

Regards


Thanks Francesco. Keep us posted and thank you for a swift answer.

Re: SQL LocalDB Support

Posted: Mon Dec 03, 2012 7:15 am
by Werner
I also realized that the plugin does not recognize LocalDB.

The plugin is not usable for us if it does not support LocalDB.

Re: SQL LocalDB Support

Posted: Mon Dec 03, 2012 12:45 pm
by FrancescoT
Dear Werner,

honestly I never used it with LocalDB.

If you want to interact from CMD windows with a LocalDB installation, do you still use "SQLExec"?

Regards

Re: SQL LocalDB Support

Posted: Tue Dec 04, 2012 2:08 am
by Werner
Hi Francesco,

I never used SQLExec from CMD window.

But after having installed SqlLocalDB.MSI (the inst file from MS for LocalDB based on SQL Server 2012 Express) I can connect to LocalDB using instance name "(localdb)\v11.0" from SQL Server 2012 Management Studio as well as from my application like to every other "normal" SQL Server 2012 database.

My app uses
SQLRETURN SQL_API SQLExecDirect
(
SQLHSTMT StatementHandle,
__in_ecount_opt(TextLength) SQLCHAR* StatementText,
SQLINTEGER TextLength
);
from SQL.h (from MS) for SQL commands.

But from InstallAware the command "Detect MS SQL instances" does not detect LocalDB instances
and "Microsoft SQL Server Script" returns errors if called with instance name "(localdb)\v11.0".

For info about LocalDB see http://msdn.microsoft.com/en-us/library/hh510202.aspx

Regards

Re: SQL LocalDB Support

Posted: Wed Dec 05, 2012 10:43 am
by FrancescoT
Dear Werner,

I will try to install the MS SQL LocalDb to verify this behaviour ... I never used it and I am not able to give you a proper answer actually.

I will be back as soon as possible.

Regards

Re: SQL LocalDB Support

Posted: Mon Jan 14, 2013 8:52 am
by Werner
Hi Francesco,

any progress in this matter ?

Regards

Werner

Re: SQL LocalDB Support

Posted: Mon Jan 14, 2013 2:14 pm
by FrancescoT
Dear Werner,

I have added this request to our feature request list, but actually I can tell when and if it will be released.

Regards

Re: SQL LocalDB Support

Posted: Tue Jan 14, 2014 3:47 pm
by chamsoft
Hi Francesco, just wondering if there has been any progress on this?

Regards
David

Re: SQL LocalDB Support

Posted: Thu Jan 16, 2014 1:23 pm
by FrancescoT
None currently.

Regards

Re: SQL LocalDB Support

Posted: Tue Mar 25, 2014 12:38 am
by chamsoft
Hi Francesco, I assume there has still been no progress on this? If not I need to work out some other way to install LocalDB myself. Could you please provide some guidance on how to use the msi provided by Microsoft from within an installaware script?

Re: SQL LocalDB Support

Posted: Tue Mar 25, 2014 12:46 pm
by FrancescoT
Dear Chamsoft,

Unfortunately, the LocalDB Runtime package is not yet included with our product.

Anyway, InstallAware is an extensible development tool and it is possible to customize or to extend its functionality.

There two possible ways to include that Runtime package with your project.

A- you could add the "LocalDB " Redist Installer distributed by Microsoft, to the Project SUPPORTDIR and then to call it using "RUN PROGRAM" from your main script. The SUPPORTDIR is a special temporary location used at Runtime by the installer. To find out how to use the SUPPORTDIR, please search for "Modifying Support Files" with the included IA documentation (just press F1 in IA IDE).

B- You can integrate additional custom runtime packages with creating a custom IA runtime package module. The document "Extending the Application Runtimes View" describes all the steps required to develop and integrate a custom IA runtime package module.
http://www.installaware.com/publications-whitepapers.htm

Hope this helps you.

Regards