|
|
|
|
|
TestBase 3.0 1 2 3 4 5 6 7 8 9 One of the biggest hurdles in developing a system is in the testing stage and determining bottlenecks. Everyone has had systems go into production that all of a sudden don't function or the performance goes through the floor. The developer's tell you that it worked just fine in testing. The only problem was that their testing database had 50MB of data while your production database had 500GB of data. There was such a small amount of data simply because generating meaningful test data takes time and effort that developers simply don't have. Therefore, most companies compromise by giving the developers a copy of the production data. That has its own problems in terms of security and writing code to the data that is currently present and not what might be there.Fortunately, there is a good alternative. TestBase from Tenerus Corporation has a very simple, yet powerful, utility to generate useful testing data for your databases that conforms to datatype restrictions and parent-child relationships. After starting TestBase, you will be prompted to create a project. Simply enter a name and click the Add button.
From here, you select the connection method to the database you want to generate data for. This would be my only complaint about the product. It supports native connection for Oracle and Sybase only. The Sybase connection will not work against SQL Server, because it is a CT-lib connection. If they would have used DB-lib, it would have been able to connect to SQL Server. This means you'll have to pop open your ODBC administrator and create a data source pointed directly at the database you want test data for. (You have no ability to switch database context, so you must do this via the data source.) You can add as many datasources as you want to with any combination of backends.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
