Hi,
I have an app that runs on MS Access or SQL Server.
However, due to the complexity of the schema, DTS and the upsizing wizard did not correctly upsize the data. I had to manually created create triggers, etc.
My problem is that i would like to automate a fool-proof way of upsizing the data for end users.
The schema can be created using ddl from a dump, i assume is the best way.
I manually imported the data using DTS, but are there any methods which are easy to deploy to end users.
I am developing app in delphi. If i'm stuck i can manually code this, but it seems like reinventing the wheel.
Thanx in advance.
I have an app that runs on MS Access or SQL Server.
However, due to the complexity of the schema, DTS and the upsizing wizard did not correctly upsize the data. I had to manually created create triggers, etc.
My problem is that i would like to automate a fool-proof way of upsizing the data for end users.
The schema can be created using ddl from a dump, i assume is the best way.
I manually imported the data using DTS, but are there any methods which are easy to deploy to end users.
I am developing app in delphi. If i'm stuck i can manually code this, but it seems like reinventing the wheel.
Thanx in advance.
