[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Replication - Easy Question

Posted on 2007-12-04
4
Medium Priority
?
244 Views
Last Modified: 2010-04-21
Hi DB Experts!

I have a quick question regarding replication. I haven't set up a DB to be replicated before but will be doing so in the near future. My main question is, once you set up replication for a database, how much work is it to add another column to a table that is being replicated? Is it pretty trivial or more involved?

Also, if you wanted to add your 2 cents on replication I wouldn't complain. Is it pretty easy to setup and maintain? Any gotchas? I'll be finding out pretty soon. ;-)

Thanks everyone!
0
Comment
Question by:CoconutTelegraph
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
i2mental earned 1000 total points
ID: 20405959
Adding a new column is not a big deal. That specific ability was added in 2000. Altering an existing table can be more complicated however.

http://www.databasejournal.com/features/mssql/article.php/1478611
0
 
LVL 8

Expert Comment

by:i2mental
ID: 20405965
I meant to say altering an existing column, not table.
0
 
LVL 18

Assisted Solution

by:Yveau
Yveau earned 1000 total points
ID: 20407259
This is a good site to start:
http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Adding a column in the publication is like using normal SQL statements ... wait for the next replication and the subscribed databases will get the modification as well. Can it get any easier ?

Easy to setup ? ... it's a database ... how hard can it get ?

Gotchas ... beside running MS Windows ? No :-)

Hope this helps ...
0
 

Author Closing Comment

by:CoconutTelegraph
ID: 31412661
Thanks y'all.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

873 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