| From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
|---|---|
| To: | Valter <pgsql(at)intersic(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Converting Data From MS-Sql Server |
| Date: | 2004-03-17 15:40:39 |
| Message-ID: | 40587177.8020706@potentialtech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Valter wrote:
> I need some hints about converting my ms-sql server database to Postgre.
>
> Are there any tools for this convertion?
I don't know of any tools, but I recenlty did this the old fashoned way.
About 130 tables, and a network of foriegn keys, indexes and other relations.
Then about 50 meg worth of data to clean up so \copy would accept it. It
took me less than 16 hours for all of that.
It then took me three weeks to convert all the MSSQL stored procedures to
Postgres, and we're still tracking down bugs in that part. (It's about
400K when dumped from MSSQL, and about 450K source file before being
imported into Postgres)
Hope that helps some.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Thomas | 2004-03-17 15:51:32 | Re: Newbie question: OT |
| Previous Message | Bill Moran | 2004-03-17 15:37:01 | Re: Newbie question: OT |