I wants to fetch the recods from one server database table to other server example local server data base table using sql 2005

Question

0.00/5 (No votes)

See more:

I wants to fetch the recods from one server database table to other server example local server data base table using sql 2005 and also provide the condition in any new records is add again in server table then after some time our local table also insert that new records and also avoid insert duplicate records

Explain withe one example inf possible then plaz send send the one little project

i am not able to understand (on our system)wat say three answer given below
can any one tell how to achive the gud solution of this prob

Thaks

Posted 28-Jan-10 20:35pm

Ganesh_verma

Updated 31-Jan-10 20:53pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2010-01-28T21:06:00

Ganesh_verma wrote:
Explain withe one example inf possible then plaz send send the one little project

If you want to give demands, you should go to the job board and offer to pay someone.

You do this the same as if they were on the same DB server, you just need two connection strings, then code to read the data from one, and code to insert it into the other, applying the conditions that you've listed. Apart from the fact that you need to do your own work, it's not possible to give you exact code without knowing your DB schema.

BTW I deleted your duplicate question.

Manas Bhardwaj · Answer 2 · 2010-01-28T21:13:00

Solution 2

You might want to look at the http://msdn.microsoft.com/en-us/library/aa933484(SQL.80).aspx[^].

Posted 28-Jan-10 21:13pm

Manas Bhardwaj

DABBee · Answer 3 · 2010-01-31T19:07:00

If it was me I'd create an SSIS server package scheduled to run at a reasonable interval.
You could mirror the databases
Look at data publishing in SQL Books On Line.
Backup the database and restore to the other
If the tables are not too big use an hetrogenous query based on the records not being in the destination table
Get creative.
Use merges.
Look up documentation on updating disconnected databases. .Net docs cover this.

Have I covered it ?

I wants to fetch the recods from one server database table to other server example local server data base table using sql 2005

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0