September 29, 2005 at 10:01 pm
Hi All,
I got two servers which uses the same database structure. Both of them are writable. One of them I'm using as the server and the other as a client. When the client gets online with the server I want to update all the new records updated in client to the server without causing any changes to the data on the server. I read somewhere that you can use stored procedures. Since I want to do this from an application I prefer to use SP instead of using the Replication wizard. Can any out there help me. Thanks in advance.
Mathew
September 29, 2005 at 10:15 pm
Why you used Stored Procedure? I think that it's not the good solution, because you must write a lot of code, even sp can do that.
Replication its a good solution for your case.
September 29, 2005 at 11:28 pm
No what I meant was using the Stored Procedures that are inbuilt with SQL Server for doing the replication task (if it is there?).
September 30, 2005 at 12:31 am
Try to make a DTS, and then the stored procedure run that DTS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply