Re: mdf

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(at)hogranch(dot)com]
Skickat: den 7 mars 2009 01:16
Till: Ary Pezo Silvano
Kopia: pgsql-general(at)postgresql(dot)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.