Hi!
Try to manintain a database at my site and at a client site.
Whenever I enter new records into tables, I need to update the clients table once a month.
I have about 100 tables in the database.
How can I update the client's tables only with new records?
Someone suggested me the replication.
I don't know much about it.
I tested it with small database with 3 tables and seems to work fine.
I thought it was great idea.
I need someone to explain to me that this will work fine 99.999% of time.
I can't mess up my table nor clients table a while I synchronize all the tables.
If you have used this tool before, could you tell me if this is straight forward process and safe to use.
any cons and pros, I must need to know..
any comments will help. Thank you much for your help in advance.
QB
Try to manintain a database at my site and at a client site.
Whenever I enter new records into tables, I need to update the clients table once a month.
I have about 100 tables in the database.
How can I update the client's tables only with new records?
Someone suggested me the replication.
I don't know much about it.
I tested it with small database with 3 tables and seems to work fine.
I thought it was great idea.
I need someone to explain to me that this will work fine 99.999% of time.
I can't mess up my table nor clients table a while I synchronize all the tables.
If you have used this tool before, could you tell me if this is straight forward process and safe to use.
any cons and pros, I must need to know..
any comments will help. Thank you much for your help in advance.
QB