Monday, March 19, 2012

open MDF file without MSDE

Hello,
I'm trying to access .mdf file (a sql server database) without having
SQL Server installed on the machine (neither MSDE).
It can be done from any programming language (like Java or C#)?
Is there anyone who knows how can I do it?
Or does a native library that can access the .mdf file exist?

Thank to anyone who can help me...

Pietro.Pietro wrote:
> Hello,
> I'm trying to access .mdf file (a sql server database) without having
> SQL Server installed on the machine (neither MSDE).
> It can be done from any programming language (like Java or C#)?
> Is there anyone who knows how can I do it?
> Or does a native library that can access the .mdf file exist?
> Thank to anyone who can help me...
> Pietro.

You can read it as a binary file of course but the only supported
method to get at SQL Server's logical data and metadata structures
(tables etc) is to use the SQL Server engine. Microsoft doesn't publish
detailed specs for the file format.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--

No comments:

Post a Comment