Re: MSSQL/ASP migration - Mailing list pgsql-general

From Tony Caduto
Subject Re: MSSQL/ASP migration
Date
Msg-id 45B4F49B.6050202@amsoftwaredesign.com
Whole thread Raw
In response to MSSQL/ASP migration  (Robert Fitzpatrick <lists@webtent.net>)
List pgsql-general
Robert Fitzpatrick wrote:
>  Any docs or other helpful info is welcome, just
> looking for some advise.
>
>
One think I would recommend is to make sure when creating the new table
structure that you make
sure not to use capitalized object names.  Because MS SQL server can be
case insensitive I have found there is always
caps somewhere, and the caps make things in Postgresql a PITA because
you have to quote everything in your application code.

You could also take a look at Lightning Admin, we have some nice import
and export wizards that can import
data from any ADO or ODBC source.

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration


pgsql-general by date:

Previous
From: "Moritz Bayer"
Date:
Subject: Re: Loop in loop
Next
From: "Simon Riggs"
Date:
Subject: Re: [HACKERS] Autovacuum Improvements