Why Is This Powerful Tool For You?

For the Developer, you are constantly looking for ways to speed up deployment, so now you can improve your delivery timelines with:

• Auto complete – speed up SQL development with the ability to auto complete what you are typing.  Complete with knowledge of your MPP syntax and schema.
• Parameterized Queries – Create SQL templates that have parameterized values making it easy to store and re-use SQL logic.
• Stored Procedure Wizard – Rapidly create and deploy stored procedures with the wizard.
• UDX Procedure Wizard – Rapidly create, test and deploy user defined scalar functions, table functions and aggregates with C++
• Query Plan Analysis, Monitoring & Viewing – The ability to watch and monitor how a query parallism is distributed on the appliance with respect to resources and quickly relate this to the query plan.
• Reverse Engineer – Reverse engineer an MPP schema with complete syntactical support.  
• Cross Platform Schema Migration – Compare a database schema within or across appliances and produce a script that will allow you to synchronize the schemas while retaining original data. Use the workbench to pull schema and data definition language (DDL) from source databases and translate this into your target system schema. Complete with recommendations on distribution and organization.