| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | Robert Fitzpatrick <lists(at)webtent(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: MSSQL/ASP migration |
| Date: | 2007-01-22 17:30:03 |
| Message-ID: | 45B4F49B.6050202@amsoftwaredesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-01-22 17:41:06 | Re: [HACKERS] Autovacuum Improvements |
| Previous Message | Bruce Momjian | 2007-01-22 17:18:46 | Re: [HACKERS] Autovacuum Improvements |