Move MS Sql 2005 Table data to Ms Sql 2012

Question

0.00/5 (No votes)

See more:

I have one Ms sql 2005 Database on my local machine and another MS sql 2012 database on Web Hosted Server, now i want to move only updated data(Records in table) from local Database to hosted server in Asp.net, can any tell me How can i do it?

Posted 26-Oct-14 22:17pm

dhiraj mane

Updated 27-Oct-14 2:42am

v2

Add a Solution

3 solutions

Solution 1

In SQL Server you have triggers available. You can set triggers to 'fire' on change of a record and then to pretty much everything you can on SQL Server. You can easily use triggers to 'do something' with changed records in a table.

Good luck!

Posted 26-Oct-14 23:03pm

Eduard Keilholz

Comments

Maciej Los 27-Oct-14 5:06am

Please, read OP question very carefully. There are 2 sql servers in different locations. In my opinion OP need to create linked server to be able to update data.

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)

Maciej Los · Accepted Answer · 2014-10-26T23:22:00

Solution 2

If i understand you well, you need to create linked server[^] to be able to move/copy data betweem servers.

Posted 26-Oct-14 23:22pm

Maciej Los

Comments

dhiraj mane 29-Oct-14 2:56am

Do you have any Link of code example? pls....

Maciej Los 29-Oct-14 5:20am

Follow the link...

dhiraj mane 1-Nov-14 1:52am

Thank's Maciej Los i solve it by Link Server.

Maciej Los 1-Nov-14 11:59am

You're very welcome ;)
Can you accept my answer as a solution?

dhiraj mane · Accepted Answer · 2014-10-31T19:54:00

Solution 3

Finally I solve that problem by Link Server[^]

Posted 31-Oct-14 19:54pm

dhiraj mane

Updated 31-Oct-14 19:59pm

v3