Trying to migrate existing replication process (which works great!) from SQL 2000 to 2005.
2005 version creates snapshot pre scripts that do table DROP.
The tables do not yet exist in the Oracle system, so I get back errors stating table can't be dropped, and replication stops. I've tried a profile with skiperrors for 20046:942, but to no avail. Is there some trick to preventing these scripts from being run, or for skipping these errors? The pre script contents are essentially DROP TABLE tablename, followed by a GO.
Error messages:
ORA-00942: table or view does not exist
(Source: MSSQL_REPL, Error number: MSSQL_REPL20046)
Get help: http://help/MSSQL_REPL20046
ORA-00942: table or view does not exist
(Source: MSSQLServer, Error number: 942)
Get help: http://help/942