Search Postgresql Archives

Re: MSSQL/ASP migration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux