Thread

1. From MSSQL to Postgres

   Roderick A. Anderson <raanders@altoplanos.net> — 2000-08-17T18:44:09Z

   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
   
   
   

2. Re: From MSSQL to Postgres

   Chris Bitmead <chrisb@nimrod.itg.telstra.com.au> — 2000-08-17T23:54:53Z

   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