dB2dB is a utility program written in Visual Basic that allows for quick and easy transformations of database record information from one database to another. Any field in one
<:s><:#278,9360>database can be linked to another field in a second database for the purposes of data transfer.
<:s><:#278,9360>
<+#>How do you use dB2dB?<-#>
<:s><:#278,9360>
<:#1390,9360>Select your source database using the dB1 button. A file box will appear that shows only files with a .dbf extension. Select a database file and click on OK. A window will appear with information on the selected database. Repeat for your target database
using the dB2 button. A window will again appear with information on the selected database. Full paths to the selected databases appear above each dB button. These fields are not editable.
<:s><:#278,9360>
Click on the list box for dB1 of the field where you have source information you wish to transfer to dB2. Directly below the box information about the selected field will appear. This information tells you the type of field and the length of the field. T
ypes of fields are C for character, N for numeric, D for date, M for memo, L for logical,. dB2dB will only convert like fields. If the source field is a date field, the target field must be a date field. Also because of the varying memo field types, dB2d
B will not link to or from any memo field. Any attempt to do so will cause a box to be displayed notifying you that linking of memo fields is not allowed. Click on the list box for dB2 of the field you wish to link with the selected field of dB1. Click o
n the Link button and a link will appear in the Link list box. Continue selecting fields in dB1 to be linked with fields in dB2. If you change your mind about a link, delink by clicking on the link information in the Link list and click on Remove Link. T
his will remove your link.
<:s><:#278,9360>
<:s><:#1671,9360>After all links have been selected, click on GO. A window will appear asking if you wish to erase the target database first if it contains any previous records. Clicking on yes erases all previous records, clicking on no adds information to the target dat
abase. <+!>If you click on yes to erase the previous information it is gone forever. Please be sure this is what you really want to do!<-!> A second window will appear informing you that the erased data will be lost forever and confirmation that this is
really what you want to do.
<:s><:#278,9360>
<:#1668,9360>The cursor will change to an hourglass as the information is transferred between the databases. The amount of time this takes will depend upon the CPU speed, hard disk speed, and the size of the databases. However, it is quite fast and on slow CPU's with
small (under 1000 records) databases should take less than 2 minutes. On fast CPU's with small (under 1000 records) databases it should take less than 10 seconds. On a 486-33 with 16mS hard drives transferring 610 records with 57 fields took 6 seconds.
<:s><:#278,9360>
<:#1112,9360>This program is placed in the public domain. The author makes no guarantees as to the appropriateness towards your application and assumes no liability for any problems or loss of data that occurs. Other than that, I hope you find this program useful. If
you have any questions my CIS ID is 76405,416, and AOL ID is BillT121.
(.txt)