Обсуждение: mdf

Ary Pezo Silvano wrote:
> hi,
>
> how can i import a mdf database into postgres?
>

do you have access to the SQL Server that this MDF file came from?
Install the Postgres client for windows, along with a Postgres ODBC
driver on that server, and use the Data Translation Services in SQL
Server Enterprise to export the data from SQL Server to Postgres (which
can be on a different server, using a postgres network connection, if
you setup everything correctly).


Otherwise, use SQL Server to export the tables seperately as CSV files,
and import them into Postgres.

Ary Pezo Silvano wrote:
> hi,
>
> how can i import a mdf database into postgres?
>
> best,
> ary

Using Access to export or connect via ODBC is probably the safest bet.

If you don't have Access....

It's listed as "alpha" software, has no "home" page on Sourceforge and
looks to have been abandoned half a decade ago but you can still follow
the download link from freshmeat and grab a copy of MDBtools
(http://freshmeat.net/projects/mdbtools/). It includes tools to export
the schema, export the data as CSV and so on. It worked for my purposes
the one or two times I tried it.

Cheers,
Steve

Steve Crawford wrote:
> Ary Pezo Silvano wrote:
>> hi,
>>
>> how can i import a mdf database into postgres?
>>
>> best,
>> ary
>
> Using Access to export or connect via ODBC is probably the safest bet.

Access natively uses JET databases, which are .MDB not .MDF ...  MDF is
SQL Server's native format.

not at -all- the same thing.

hi,

thank you for your comments.

my problem is that the mdf file has been sent to me by email in a zip file.
i extracted the file and it is 8 GB.
i don't know how i should import or open it with postgres.

best,
ary

________________________________________
Från: John R Pierce [pierce@hogranch.com]
Skickat: den 7 mars 2009 01:16
Till: Ary Pezo Silvano
Kopia: pgsql-general@postgresql.org
Ämne: Re: [GENERAL] mdf

Ary Pezo Silvano wrote:
> hi,
>
> how can i import a mdf database into postgres?
>

do you have access to the SQL Server that this MDF file came from?
Install the Postgres client for windows, along with a Postgres ODBC
driver on that server, and use the Data Translation Services in SQL
Server Enterprise to export the data from SQL Server to Postgres (which
can be on a different server, using a postgres network connection, if
you setup everything correctly).


Otherwise, use SQL Server to export the tables seperately as CSV files,
and import them into Postgres.

There are a couple of tools that will open an MDF file buy you have to
pay for them
http://www.sqldatabaserepair.com/
http://www.mssqldatabaserecovery.com/


Another option is you need to learn how the MSSQL server is setup, and
what version.

Get your hands on that Version of SQL install it and copy this file
into the data directory then try to mount it. 

If you fail to duplicate the setup of the server that created mdf file
it can't be mounted.  It will tell you the reason. 

It would be easier if the people that sent you the MDF did a backup of
the MSSQL Server, send you the backup, download a eval of MSSQL restore
the backup then migrate.


Ary Pezo Silvano wrote:
<blockquote
 cite="mid:E86514FD1C66B54FB40BC238CEA6C4500DC2C9DD01@MAIL01.ug.kth.se"
 type="cite">
  hi,

thank you for your comments.

my problem is that the mdf file has been sent to me by email in a zip file.
i extracted the file and it is 8 GB.
i don't know how i should import or open it with postgres.

best,
ary

________________________________________
Från: John R Pierce [pierce@hogranch.com]
Skickat: den 7 mars 2009 01:16
Till: Ary Pezo Silvano
Kopia: pgsql-general@postgresql.org
Ämne: Re: [GENERAL] mdf

Ary Pezo Silvano wrote:


    hi,

how can i import a mdf database into postgres?




do you have access to the SQL Server that this MDF file came from?
Install the Postgres client for windows, along with a Postgres ODBC
driver on that server, and use the Data Translation Services in SQL
Server Enterprise to export the data from SQL Server to Postgres (which
can be on a different server, using a postgres network connection, if
you setup everything correctly).


Otherwise, use SQL Server to export the tables seperately as CSV files,
and import them into Postgres.

John R Pierce wrote:
> ...
> Access natively uses JET databases, which are .MDB not .MDF ...
MDF? MDB? All looks the same late on Friday when you mind is shifting
gears to the pint of Guinness waiting for you after work. :)

Cheers,
Steve