How to export sql data from one server to another server using script/code?

Question

0.00/5 (No votes)

See more:

, +

I have a Live database on Server1 on which data is feeded frequently(daily). I need to access this on different sever(Server2) which needs to be updated every week with the data from Server1. How do we do this?

I have no idea of how to begin. A bit of investigation helped me know about Sql Job Agents, but i need to do this using code (preferably C#) , so that data updation occurs automatically on the destination server. Can someone please tell me other ways to do this?

Currently i have to manually take backup from server1 and restore it on server2. How can we automate this?

Posted 2-Nov-15 19:58pm

Member 12108821

Updated 2-Nov-15 20:01pm

v2

Add a Solution

1 solution

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)

amagitech · Answer 1 · 2015-11-02T20:12:00

Solution 1

Example:
Sunday 00:00 get an backup from database

Write an console program to update your database to another server.
And use windows scheduled task to starting program sunday 00:15;

Posted 2-Nov-15 20:12pm

amagitech