Figure 1
When you click 'File->Choose Source DBMS' from the main menu, the Source/Destination Window is displayed.
The window contains two frames, Source and Destination.
The Source Frame is displayed immediately when the window opens (Figure 1).
The Source Frame will differ slightly depending on your source DBMS' requirements, but essentially it allows you to enter your login credentials,
and to subsequently choose the data objects you wish to export to your destination database.
The first step is to enter your login credentials and choose the Object Types you wish to export to your destination database.
Data2Data™ will construct and implement a default connection string based on the login credentials you enter.
(Optionally, you can choose to manually enter a connection string by clicking on the appropriate radio button.)
Next, in the Object Type list, click the checkboxes that correspond to the object type(s) you wish to export. You can choose
any or all of the following: Tables, Primary Keys, Foreign Keys, Indexes, and Views. After entering your login credentials
(or connection string) and choosing your Object Types, click the Login button.
Figure 2
When you click the login button, Data2Data™ logs into your source database and reads its schema.
Once this process is complete, each of the objects that correspond to the object types you chose will be displayed hierarchically
in the lower half of the Source Frame (Figure 2). Tables and Views are displayed at the highest level. Under each table will
be listed its Primary Keys, Foreign Keys, and Indexes. At this point you can choose the individual objects you wish to export.
(You need not check each object individually; checking any object will cause all of its "child" objects to be checked also.)
Once you've chosen the objects you wish to export, you must choose the .NET provider for the destination database from
the Destination DBMS Provider combo box underneath the Source Frame. The combo box lists all .NET providers installed on your machine.
Note that at the current time Data2Data™ only supports Sql Server, Oracle, and MySql as destinations.
If you choose some other provider, you will receive a message saying that it's not currently supported.
After choosing your destination DBMS' .NET provider, clicking the Continue button will cause the Source/Destination Window
to expand, and the Destination Frame that corresponds with your chosen destination DBMS will be displayed to the right of
the Source Frame (Figure 3). As you did in the Source Frame, you must also login to your destination database from within
the Destination Frame. As with the Source Frame, each Destination Frame differs slightly depending on the chosen destination DBMS.
Figure 3
After entering your login credentials, you can choose whether to export only the data objects from your source database,
or to copy all the data as well. You can indicate your choice by clicking the appropriate radio button located underneath
the Destination Frame. Then, click the Export button to begin the export process.
When the export process is completed, you will receive a message that tells you whether the export was successful,
partially successful, or not successful. For details about the results or any errors encountered, you can check the
various logs generated by Data2Data™. A running status
is displayed at the bottom of the Main Window so you can tell how far along the process is at any give time. You can also
cancel the process in progress if you wish, by clickin clicking the Stop button. (The Stop button takes the place of the
Export button once the export process is underway.)