Thread: mdf
hi,
how can i import a mdf database into postgres?
best,
ary
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