Download the FREE Toad Data Point Viewer
Toad Intelligence Central on Quest.com
Toad Intelligence Central Community on ToadWorld
Product Information on Quest.com
Toad Data Point Release Notes and Product Guides
Get more from Toad Data Point...
with onsite training
Toad™ Data Point is a multi-platform data preparation tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare data to produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:
Toad Data Point v4.2 is now available
Check out what's new!
Use these links below to learn more about the most popular Toad Data Point topics!
I have used data compare with Excel data connections before and it works great. I tried to do one on a database yesterday, and after the compare wizard analyzed the databases, it displayed a list of tables. I want to select only a handful of the tables, and choose which columns to compare. Is this possible? Or do I have to construct select statements choosing the tables and columns, export the data to Excel, and then use Excel data connections? I didn't want to have to create a bunch of Excel connections, which is why I went the database route.
Is there an efficient approach to transpose a given table so that it results in the following:
Primary Key | Field | Value
1 Field 1 Value
1 Field 2 Value
1 Field 3 Value
2 Field 1 Value
2 Field 2 Value
2 Field 3 Value
I would like to be able to do this for 2 or more similar tables and then join them back by primary key and Field in order to compare there values.
We're trying to determine the best upgrade path from TDP 3.8 32-bit, to TSP 4.2 64-bit, while keeping the user's settings as they were.
I personally do not have control over the installer, it is done via MSI, and executed by our packaging group guy, for rollout to many machines in enterprise. I am testing it now, and hitting some issues.
1. If he installs 4.2 64-bit, it is not recognized as an upgrade, and so none of my prior settings are migrated (connections, UI settings , etc.) We've tried manually forcing it, but still nothing is migrated. 2. If he installs 4.2 32-bit, then I get the migration popups and warnings, as expected,and my customizations are brought over.
Is going from 3.8 32-bit to 4.2 64-bit a valid migration path?If not, is there any recommended best practice for how to end up at 4.2 64-bit while keeping my 3.8 settings? That's what we need to do, but can't see how yet.