DBGizmo  A serious tool for busy SQL Server database professionals.
        Home         General         Features         Screens         Editions         Download         Purchase        
The best way to learn more about DBGizmo is to download a free demo now!
DBGizmo's features for exploring and analyzing database structure, table relationships, SQL routines, and object dependencies were designed to assemble the schema information needed by database workers in one convenient location. The ability to display schema information is certainly not unique, but the way DBGizmo presents schema information is especially useful. The details for related tables or dependent objects are only a click away. Database architects, developers, and administrators can take advantage of DBGizmo all day every day.
DBGizmo's features for generating SQL code are absolutely amazing. The features are loosely divided into two kinds, data manipulation (DML SQL code) and schema manipulation (DDL SQL code). The generation of SQL code for data manipulation (DML) is primarily on the SQL tab and the generation of SQL code for schema manipulation (DDL) is on the SQL tab. The DBGizmo features included on each tab are equivalent to the functionality of two utility products
from other sources. Discover the fantastic power of the code generation features.
There are many other SQL Server utility products whose sole functionality is no more significant than a single code generation feature in DBGizmo!
  SQL - Process All Rows in Selected Tables
The functionality found on the left side of the SQL tab is similar to many Data Compare products, but it takes a very different approach. The Data Compare products generate INSERT and UPDATE statements with literal data embedded in them. These SQL statements are good for a one-time synchronization task only. Any subsequent synchronization task requires another session in a GUI to generate new SQL statements with different literal data embedded in them. DBGizmo has a better way. DBGizmo generates SQL statements that can be used repeatedly. DBGizmo puts the data comparison logic into the generated SQL code instead of keeping it hidden within a Data Compare application. As an example, the generated SQL code could be used to quickly and easily restore the data in a development database to a known state, no matter what data (if any) had been changed.
  SQL - Process a Set of Related Rows in Related Tables
The functionality found on the right side of the SQL tab is unlike any other tool/product. This DBGizmo feature takes a row (or a set of rows) from a high level table and gathers every related row in every related table. The collection of sets of rows comes from the high level table and all descendent (subordinate) tables. The rows can be copied to another database and/or deleted from the source database. This functionality is implemented with generated SQL code, not with literal data. The SQL code could be placed into a stored procedure that accepts a primary key as a parameter. If the primary key happens to identify a certain client then that client (out of many clients) along with all their contact data, business data, and payment data can be processed as a unit. As an example, the generated SQL code could be used to copy all the associated data for one client (out of many clients) into an archive database and then delete (purge) that data from the production database.
  SQL - Generate SQL Code for Selected Tables
The functionality found on the SQL tab is quite extensive. Some options are relatively simple in nature, while other options are very significant. There's a button to generate SQL code for creating CRUD stored procedures and triggers. DBGizmo goes beyond similar products by providing a stored procedure variation for each foreign key. There's a button to generate VB.NET code files (one core module and a class for each table) to help take advantage of the generated CRUD stored procedures. The properties and methods of each class handle the usual needs for a data access layer. There are two buttons to generate SQL code for data change tracking systems consisting of extra tables and triggers for auditing. The two choices implement different methods having different characteristics for different requirements. Both options reliably capture all data changes. Several buttons on the SQL tab provide SQL code to promote consistency in object names.
Copyright 2021 Wingenious