Re: From MSSQL to Postgres - Mailing list pgsql-general

From Chris Bitmead
Subject Re: From MSSQL to Postgres
Date
Msg-id 399C7B4D.1C487997@nimrod.itg.telecom.com.au
Whole thread Raw
In response to From MSSQL to Postgres  ("Roderick A. Anderson" <raanders@altoplanos.net>)
List pgsql-general
Ouch. I think you are seriously out of luck. Can you get an eval copy of
SQL Server? You need to dump the data as insert statements or something.

"Roderick A. Anderson" wrote:
>
> I've got a real serious problem that isn't working out well.  I'm trying
> to migrate a web based appliation from WINNT/MSSQL(6.5)/IIS to the real
> world (Linux/PostreSQL/Apache).
>    The sticky bit is getting the data from the SQL Server data format
> (yes data format) to a PostgreSQLable format.  The tricky parts are:
>
>         I have the data files on tape
>         They deleted WINNT and installed WIN2000 on the old system
>         They were never given the SQL Server CDROM
>                 We don't have a copy of SQL Server 6.5 (though there is a
>                 demo copy of SQL Server 7.0 floating around here.)
>
> I'm looking for solutions!  Are there any tricks to get from the data
> files to a PostgreSQL usable format.
>    I can do perl so if I had the format I possibly slice and dice them up.
>
> I'm still searching but hope from the number of messages about getting
> from there (M$) to here (PostreSQL) there might be an expert floating out
> and about.
>
> BTW, This is for a non-profit so going out and buying a copy of SQL
> Server for the one time use isn't viable.
>
> TIA,
> Rod
> --
> Roderick A. Anderson
> raanders@altoplanos.net               Altoplanos Information Systems, Inc.
> Voice: 208.765.6149                            212 S. 11th Street, Suite 5
> FAX: 208.664.5299                                  Coeur d'Alene, ID 83814

pgsql-general by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: OID decreasing?
Next
From: "Andrew Snow"
Date:
Subject: RE: OID decreasing?