ASP.NET Discussion - update two database in sql server

Print Page | Close Window

update two database in sql server

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4572
Printed Date: 28 March 2026 at 4:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: update two database in sql server

Posted By: nima555ir
Subject: update two database in sql server
Date Posted: 28 July 2003 at 1:15pm

i have two database in sql server that they are in different server.

there are an customer table in them but one of them is always newer than other.

i want to write some code that update the older table with the newer one but i want only edited data ,inserted data and deleted data perform on older table not all records replaced.

plz help me

thanks

Replies:

Posted By: Bunce
Date Posted: 28 July 2003 at 7:10pm

Do you have permissions on one of the servers to run a DTS script?

If so, that would be the easiest way to go.

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: nima555ir
Date Posted: 29 July 2003 at 2:43am

yes i have a permission to run a dts script.

one of my server is local.

what do i do?