Hi all,
I have SQL Server 2000, and our accounting package that has an OLE DB driver. I want to set up the SQL server to have a mirror of the accounting package data that will be updated each night. I've been able to import the data via a DTS package, but I'm sure there must be a more efficient way. For example, some of the tables are 'master' tables ie. each record may be for a single customer (these would need to be cleared, and fully imported again), and other tables are 'transaction' tables (these would only need new records imported).
Can anyone give me some advice on how I go about making an efficient package to do this?
Thanks.
I have SQL Server 2000, and our accounting package that has an OLE DB driver. I want to set up the SQL server to have a mirror of the accounting package data that will be updated each night. I've been able to import the data via a DTS package, but I'm sure there must be a more efficient way. For example, some of the tables are 'master' tables ie. each record may be for a single customer (these would need to be cleared, and fully imported again), and other tables are 'transaction' tables (these would only need new records imported).
Can anyone give me some advice on how I go about making an efficient package to do this?
Thanks.