Re: From MSSQL to Postgres

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема Re: From MSSQL to Postgres
Дата
Msg-id 399C7B4D.1C487997@nimrod.itg.telecom.com.au
обсуждение исходный текст
Ответ на From MSSQL to Postgres  ("Roderick A. Anderson" <raanders@altoplanos.net>)
Список 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 по дате отправления:

Предыдущее
От: Chris Bitmead
Дата:
Сообщение: Re: OID decreasing?
Следующее
От: "Andrew Snow"
Дата:
Сообщение: RE: OID decreasing?