PowerDesigner Tips & Tricks for ASE & Rep Server Users

John will draw from his years of database design experience with Power Designer and concentrate on logical and physical data modelling rather than UML and requirements analysis. The emphasis will be on practical techniques that work well, including generating documentation in Microsoft Word format.

This is not a ‘how to’ presentation on database design, it is intended to show database designers how to get the best from Power Designer as a CASE tool. The logical data modelling part is inherently implementation neutral so it will suit all designers, irrespective of the final target RDBMS (e.g. Sybase, Oracle, Microsoft, MySQL, Postgres etc). John has used PD to design and develop Sybase and Microsoft and MySQL systems, and he will share some experience of that – including customising DBMS resource files to embed version management references in database objects.

Sybase replication system design is supported by Power Designer’s ‘Information Liquidity Model’ (ILM). Mott MacDonald has made extensive use of replication systems and John helped design them. He will demonstrate how PD was used for documentation and compare PD’s RCL generator with older, more ‘manual’, approaches.

During this session you will learn how to;

• prepare for ASE migrations and upgrades by generating accurate and detailed physical data models of your databases
• improve system stability by tracking DDL changes through data model deltas
• boost change management processes by utilising PowerDesigner reports as a change review function