PGCon2007 - Confirmed

PGCon 2007
The PostgreSQL Conference

Speakers
Radovan Jablonovsky
Schedule
Day 3
Room SITE B0138
Start time 13:30
Duration 01:00
Info
ID 9
Event type Workshop
Track Basics
Language English
Feedback

Practical experience with moving applications to PostgreSQL

Porting challanges: Database design, human factor

Practical experience with redesigning and moving applications from MSSQL, Paradox and Access to PostgreSQL. Pinpoint challenges in database design, data migration, propagation of PostgreSQL inside company (human factor), introduction to novice developer(s), database GUI tools (CASE, SQL editors, graphical query builder, administration tools).

Experience from redesigning and moving applications from MSSQL, Paradox and Access to PostgreSQL. Pinpoint challenges in database design, data migration, propagation of PostgreSQL inside company, introduction to novice developer(s), database GUI tools. Human factor in decision process of choosing RDBMS. Importance of reliable CASE tool(s), SQL editors, graphical query builder, administration tool(s). Practical solution to: - Difference between MSSQL and Postgresql. SQL, case sensitivity, index usage, scalability - Difference between T-SQL and PL/pgSQL