Re: mdf

From: justin <justin(at)emproshunts(dot)com>
To: Ary Pezo Silvano <aryps(at)kth(dot)se>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: mdf
Date: 2009-03-09 15:15:40
Message-ID: 49B5329C.4000400@emproshunts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
There are a couple of tools that will open an MDF file buy you have to
pay for them <br>
<a class="moz-txt-link-freetext" href="http://www.sqldatabaserepair.com/">http://www.sqldatabaserepair.com/</a><br>
<a class="moz-txt-link-freetext" href="http://www.mssqldatabaserecovery.com/">http://www.mssqldatabaserecovery.com/</a><br>
<br>
<br>
Another option is you need to learn how the MSSQL server is setup, and
what version.<br>
<br>
Get your hands on that Version of SQL install it and copy this file
into the data directory then try to mount it.&nbsp; <br>
<br>
If you fail to duplicate the setup of the server that created mdf file
it can't be mounted.&nbsp; It will tell you the reason.&nbsp; <br>
<br>
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.<br>
<br>
<br>
Ary Pezo Silvano wrote:
<blockquote
cite="mid:E86514FD1C66B54FB40BC238CEA6C4500DC2C9DD01(at)MAIL01(dot)ug(dot)kth(dot)se"
type="cite">
<pre wrap="">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&aring;n: John R Pierce [<a class="moz-txt-link-abbreviated" href="mailto:pierce(at)hogranch(dot)com">pierce(at)hogranch(dot)com</a>]
Skickat: den 7 mars 2009 01:16
Till: Ary Pezo Silvano
Kopia: <a class="moz-txt-link-abbreviated" href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a>
&Auml;mne: Re: [GENERAL] mdf

Ary Pezo Silvano wrote:
</pre>
<blockquote type="cite">
<pre wrap="">hi,

how can i import a mdf database into postgres?

</pre>
</blockquote>
<pre wrap=""><!---->
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.
</pre>
</blockquote>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.5 KB

In response to

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

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-03-09 15:25:55 Re: Sequences change in a rolled-back transactions
Previous Message Erwin Moller 2009-03-09 15:14:13 Sequences change in a rolled-back transactions