Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajesha
Starting Member
36 Posts |
 Posted - 2002-06-28 : 00:34:35
|
| 1)i want to know if i did some structure changes in source table of a publishing database.will this get replicate in destination table or i have make changes in destination also.2)if i create a table or database in source and can i replicate this new table or database to destination without creating these tables and database in destination serverpl help me? |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-06-28 : 06:44:59
|
| This holds true for transactional replication one-way, the other types i'm unsure.1) You will not be able to make changes to a published table as it will tell you it is published for replication and can't be modified. How easy it is to change the table depends on which version of SQL Server you are using. SQL6.5 & SQL2K - you can drop the table you wish to change from replication - modify it - and replicate it again. SQL7 - trickier as the ability to remove one table only does not exist. You'll have to stop replication - make your changes and replicate everything. 2) The replication procedure itself places the tables at the destination, you need do nothing but create at the source and replicate it.Paul |
 |
|
|
|
|
|
will the source table structure get replicate in d