Solved

SQL Server 2005 data replication

Posted on 2007-12-04
5
209 Views
Last Modified: 2010-04-21
Dear Gurus,
We currently have data on SQL server 2000 in our office server.
We need to replicate data from the SQL server in our office(CA) to the disaster recovery server(TX) at a remote location on a daily basis.

We are looking at a product caled "WanSync" to serve this purpose, but it is expensive.

Is there functionality in SQL Server 2005 that has features for data replication from one server to a remote server? In that case we wont have to buy "WanSync" & can upgrade from SQL Server 2000 to SQL Server 2005.

Please advise.

Thanks
0
Comment
Question by:vdesai_8
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:Yveau
ID: 20407095
How about the replication feature of SQL Server ?
http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Hope this helps ...
0
 

Author Comment

by:vdesai_8
ID: 20407463
Thanks Yveau. is it too much work to configure the servers for replication or is it fairly easy? The reason I am asking is that, I am not very proficient with setting up Sql replication hence would have to refer to some books. Do you think setting up replication is pretty straightforward or is it complicated? Are there any good books that explain the process step by step?
0
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
ID: 20407503
It's pretty straightforward. Make sure o think it over good and choose the proper kind of replication for you needs. That will be 80% of the hard work. The rest is just 'a few clicks away' :-)

Here is a good 'manual':
http://msdn2.microsoft.com/en-us/library/ms151866.aspx

Hope this helps ...
0
 

Author Closing Comment

by:vdesai_8
ID: 31412697
Thanks for your help.
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20409155
You're welcom and thanks for the grade !
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
databases from multiple applications - same instance 6 40
SQL syntax for max(date) 3 39
Need split for SQL data 7 48
Importing from CSV to SSMS 2 9
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question