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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Bulk Copy - Error(Trans. Replication)

Author  Topic 

nbpatil
Starting Member

14 Posts

Posted - 2004-10-24 : 23:09:01
Hi ..
I have queries regarding Transactional Replication.
1)I have DB1 as main database.I have set Transactinal Replication with SCHEMA and DATA to be copied to DB2.It creates snapshot and creates tables in DB2.But while copying the data from DB1 to DB2, it fails.The error message is 'AN INVALID BCP(Bulk Copy Prog.)COMMAND ISSUED'.
2)I want to transfer whole database with all objects from DB1 to DB2 on the same server. How it can be done without getting BCP command Error.

Anybody have solution over this problem?

Regards
Nitin
------------------------------------------------------------------
   

- Advertisement -