Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving from SQL Server to PostgreSQL experiences
Message
De
31/07/2016 07:57:59
 
 
À
30/07/2016 12:26:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01638967
Message ID:
01638975
Vues:
100
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform