DataGate Studio Reference Manuals

Comparison of Database Manager and DataGate Studio

The venerable predecessor of DataGate Studio, ASNA Database Manager, uses the DataGate COM client library for database access. Database Manager has been retired from the ASNA product lineup following the release of DataGate Studio 9.1.

Former users of Database Manager will find new featuress and enhancement to many of the replacement functions implemented by DataGate Studio. Some of these and other comparisons are listed below.

Active Directory Access

Database Manager DataGate Studio
Database Manager allows you to browse the database in its Active Dictionary pane, which is the primary axis for most management tasks. Similarly, DataGate Studio offers the DataGate Explorer tool, which presents database servers, connections, and database names in a tree view control. You browse the database by expanding a connection node, which represents a live view of the database.

File Definition Access

Database Manager DataGate Studio
Database Manager provides the Definition Work Area pane for viewing and designing database file definitions. Database Manager does not provide a way to save file definitions outside of the database. DataGate Studio offers an XML-based, graphical designer view of file definitions, in a standard document window. DataGate Studio file definitions can be saved as source code files and arranged in a DataGate project as well.

Data Area Access

Database Manager DataGate Studio
Database Manager does not provide access to data area objects. DataGate Studio fully supports data areas in DataGate/400 and DataGate for SQL Server databases.

File Editing

Database Manager DataGate Studio
Database Manager invokes the Acceler8DB File Editor, a grid-based viewer to display and update database files. DataGate Studio allows you to display and update files using two different integrated viewers, which are displayed as document windows.
  • Single-row editor - useful for files with duplicate keys. It displays one record at a time for editing, and provides controls for navigating through the file.
  • Multi-row editor -grid-based, with scrollbars for navigating the records and fields.

Archiving

Database Manager DataGate Studio
The Database Manager Archive utility provided a way to import and export files and data to and from DataGate for Windows databases. Note that Database Manager archive files cannot be used in DataGate Studio. DataGate Studio™s Import/Export tool is a client/server-based archiving scheme, which allows you to import to, and export from, any DataGate database; including DataGate/400 and DataGate for SQL Server. Export file catalog browsing is much improved in comparison to Database Manager archiving.

Print File Designer

Database Manager DataGate Studio
Database Manager can only manipulate OLE print files by invoking the Acceler8DB Print File Editor. DataGate Studio integrates the .NET Print File Designer (originally delivered with ASNA Visual RPG for .NET), and enhances it to provide a code view of the underlying XML document. Note that .NET print files can only be used with DataGate for .NET, and OLE print files cannot be used with DataGate for .NET. However, DataGate Studio includes a conversion utility to help upgrade your existing OLE print files to .NET print files.

Database Name Registration

Database Manager DataGate Studio
Database Manager saves database name Connection information in the Windows registry. DataGate Studio still honors database name information in the registry, but newly-created database names are now saved to a .NET configuration file. This scheme prevents unnecessary use of the Windows registry, which is less broadly accessible in current Windows operating systems. Note that .NET configuration file based database names are only available to the DataGate .NET data provider (not Database Manager or DataGate COM).

Connection Information Management

Database Manager DataGate Studio
Database Manager can only access databases for which a database name has been registered. DataGate Studio allows connections todatabases without the use of a database name. The process of entering database connection information has been streamlined, and includes a test function, which allows you to confirm the validity of connection parameters as they are entered. Database connections are managed independently of database names in DataGate Studio. However, connections may also be based on database names.