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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-12 : 07:24:45
|
| Tayyab writes "We want to replicate some of the fields data from client to server database using Transactional Replication. But during replication distribution agent gives error "Cannot Bulk Copy to Table". I searched out the error and it is due to number of columns, or datatypes , nullables are different. My client database contains all the nullable fields and data types are same. My client has installed SQL Server 2000 Personal Edition with operating system Windows XP 2002 version and server has SQL Server 2000 Enterprise Edition with Windows 2000 Server installed.My questions are:1) Is it possible in Transactional Replication that we just replicate some of the fields? 2) What is the solution to above problem?" |
|
|
|
|
|
Transactional Replication