Wednesday, March 21, 2012

Installed VS11 beta or seen references to the new SQL Server LocalDB? Did you know there was a command line management tool included? Say hello to SqlLocalDB.exe

Kodyaz Development Resources - SQL Server LocalDB Management Utility SqlLocalDB.exe

"SQL Server LocalDB is a lightweight, easy to use database for application developers. Microsoft SQL Server LocalDB requires minimum effort for database management so that it enables developers concantrate on application development rather than database administration.

A SQL Server Express LocalDB database is managed by the SqlLocalDB.exe management utility. In BOL (Books OnLine), you may also read about LocalDBManager.exe management utility, but with Microsoft SQL Server Denali CTP3 release, in Tools folder there was no LocalDBManager.exe binary file. Probably, this is a documentation error or the LocalDB management utility was changed between documentation and release date.

SQL Server Express LocalDB Management Utility :
Folder : D:\Program Files\Microsoft SQL Server\110\Tools\Binn
File : SqlLocalDB.exe

Developers that use SQL Server LocalDB as database for their application's storage needs can use SqlLocalDB.exe over CMD Windows.

...

image..."

In the coming months and years we'll be hearing more about LocalDB (think SQL Express but easier) so wanted to capture this tidbit (as I know in six months I'm going to need this but forget the details...)

 

Related Past Post XRef:
Denali CTP3 introduces LocalDB - Think SQL Server Express crossed with SQL CE (or SQL CE grown up or SQL Express made as almost as easy CE)

No comments:

Post a Comment

NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...

ALL comments are moderated. I will review every comment before it will appear on the blog.

Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...

I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...

Please see my comment policy for more information if you are interested.

Thanks,
Greg

PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...