Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving from SQL Server to PostgreSQL experiences
Message
From
31/07/2016 07:57:59
 
 
To
30/07/2016 12:26:54
Victor Chigne
Inteliventas
Peru
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01638967
Message ID:
01638975
Views:
101
>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
Map
View

Click here to load this message in the networking platform