Copy data from sql server database to another database

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

i have a database in sql server 2008

this data base is connected by an application that add and remove and edit records on its tables

i want for each change on this database the same change happen to another database which is similar to this one on another sql server 2008 on another server

some one told me i can do it using the replication feature in sql server 2008

can any one tell me how to do this?

Posted 30-May-12 3:11am

amir tarek

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)

Corporal Agarn · Answer 1 · 2012-05-30T03:15:00

Solution 1

Look at SQL Server Replication[^]

Posted 30-May-12 3:15am

Corporal Agarn

Comments

amir tarek 30-May-12 9:21am

i read it before but i want to know how can i make this work in the sql server

Arunprasath Natarajan · Answer 2 · 2012-05-30T03:33:00

Solution 2

Dear Amir,

Check this link, Hope it will help you.

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]

Regards,
AP

Posted 30-May-12 3:33am

Arunprasath Natarajan

Sandeep Mewara · Answer 3 · 2012-05-30T03:35:00

Solution 3

Apart from djj55 link provided, look at these to get more info:
CP: SQL Server 2000 - Merge Replication Step by Step Procedure[^]
Implementing Transactional Replication [^]
MSDN: Implementing Master-Subordinate Snapshot Replication Using SQL Server[^]
SQL Server Replication[^]
Copying Data Between Servers[^]
How To Implement Bidirectional Transactional Replication[^]

Have a look at them and decide on the best way to keep a copy of your database.

Posted 30-May-12 3:35am

Sandeep Mewara

Comments

amir tarek 31-May-12 7:35am

i have a problem

i succeeded to create transaction replication when using the subscriber and the publisher on the same computer

when i tried to make a subscriber as another server i want to put its ip as the subscriber server

it is error SQL Server replication requires the actual server name to make a connection to the server.

i tried to make new alias and use it but the same error happened what can i do:?