SQL LocalDB Support

[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!

[FrancescoT]

Dear John,

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

Regards

[erausner]

So, what happened in regards to this thread?

[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

[erausner]

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.

[Werner]

I also realized that the plugin does not recognize LocalDB.

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

[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

[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

[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

[Werner]

Hi Francesco,

any progress in this matter ?

Regards

Werner

[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

[chamsoft]

Hi Francesco, just wondering if there has been any progress on this?

Regards
David

[FrancescoT]

None currently.

Regards

[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?

[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