"David Gray" <grayd@turpin-distribution.com> wrote in message
news:cp7b53lslvkgb38vk77n12avegjgrqgdk9@4ax.com...
>
> Hi,
>
> Currently our core system runs on OpenVMS with the data stored in
> Oracle Rdb (that's not RDBMS).
>
> Rdb includes a product called LogMiner which unloads the days
> transactions from the transaction logs (After image journals in Rdb
> parlance) into a delimted file, the structure of which is
>
> D, table-name, "entrire row data"
> M, table-name, "entrire row data"
>
> D is deleted and M is added or modified.
>
> We have a VB6 program which goes through this matching up file
> deleting or update/adding based on the PKs.
>
> Does anyone know of any products out there that can do something like
> this that can be scheduled and handle 500,000 rows per day?
>
> Our target server is SQL2000 but soon to be SQL2005 on 64bit windows.
>
> The VB6 program cannot easily be converted to 64bit easily and is
> buggy anyway.
>
> Thanks
>
> Dave
>
>
>
>
>
>

"David Gray" <grayd@turpin-distribution.com> wrote in message
news:cp7b53lslvkgb38vk77n12avegjgrqgdk9@4ax.com...
>
> Hi,
>
> Currently our core system runs on OpenVMS with the data stored in
> Oracle Rdb (that's not RDBMS).
>
> Rdb includes a product called LogMiner which unloads the days
> transactions from the transaction logs (After image journals in Rdb
> parlance) into a delimted file, the structure of which is
>
> D, table-name, "entrire row data"
> M, table-name, "entrire row data"
>
> D is deleted and M is added or modified.
>
> We have a VB6 program which goes through this matching up file
> deleting or update/adding based on the PKs.
>
> Does anyone know of any products out there that can do something like
> this that can be scheduled and handle 500,000 rows per day?
>
> Our target server is SQL2000 but soon to be SQL2005 on 64bit windows.
>
> The VB6 program cannot easily be converted to 64bit easily and is
> buggy anyway.
>
> Thanks
>
> Dave
>
>
>
>
>
>

<hilary.cotter@gmail.com> wrote:

>DataMirror.
>"David Gray" <grayd@turpin-distribution.com> wrote in message
>news:cp7b53lslvkgb38vk77n12avegjgrqgdk9@4ax.com...
>>
>> Hi,
>>
>> Currently our core system runs on OpenVMS with the data stored in
>> Oracle Rdb (that's not RDBMS).
>>
>> Rdb includes a product called LogMiner which unloads the days
>> transactions from the transaction logs (After image journals in Rdb
>> parlance) into a delimted file, the structure of which is
>>
>> D, table-name, "entrire row data"
>> M, table-name, "entrire row data"
>>
>> D is deleted and M is added or modified.
>>
>> We have a VB6 program which goes through this matching up file
>> deleting or update/adding based on the PKs.
>>
>> Does anyone know of any products out there that can do something like
>> this that can be scheduled and handle 500,000 rows per day?
>>
>> Our target server is SQL2000 but soon to be SQL2005 on 64bit windows.
>>
>> The VB6 program cannot easily be converted to 64bit easily and is
>> buggy anyway.
>>
>> Thanks
>>
>> Dave
>>
>>
>>
>>
>>
>>