Re: mdf

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Ary Pezo Silvano <aryps(at)kth(dot)se>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: mdf
Date: 2009-03-07 00:16:17
Message-ID: 49B1BCD1.5080503@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

  • mdf at 2009-03-06 23:37:52 from Ary Pezo Silvano

Responses

  • Re: mdf at 2009-03-09 14:53:10 from Ary Pezo Silvano

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2009-03-07 01:26:34 Re: mdf
Previous Message Ary Pezo Silvano 2009-03-06 23:37:52 mdf