General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows Server 2012
>Hello.
>We are in the planning stage to move our ERP from SQL Server to PostgreSql.
>We rely heavily in Stored Procedures and remote views and want to change as little code as possible.
>We have ported our databases to PostgreSQL (now we are doing the pk replacements) and would like to know any tips or experiences you have about this.
While I haven't done a migration, I've been spending some time with PostgreSQL lately. The first big hurdle, in my view, is that it's case-sensitive for table and field names. Best practice is to make everything lowercase, since that's the default. If not, you have to live in a world of double-quotes.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only