From MSSQL to Postgres
От | Roderick A. Anderson |
---|---|
Тема | From MSSQL to Postgres |
Дата | |
Msg-id | Pine.LNX.4.04.10008171100130.14997-100000@asgard.altoplanos.net обсуждение исходный текст |
Список | pgsql-general |
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 по дате отправления: