Re: From MSSQL to Postgres

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(at)altoplanos(dot)net Altoplanos Information Systems, Inc.
> Voice: 208.765.6149 212 S. 11th Street, Suite 5
> FAX: 208.664.5299 Coeur d'Alene, ID 83814