replication started working, but have other problem.

On sql server object name for example ie test, on db2 created as "test" and all columns contained symbol ".

How create without "?

have other error

"

create table MSREPL7 (pubsrv VARCHAR (128), ...

shema?COLLECTION in QSYS type *N not found SQLSTATE: 42704, SQLCODE: -204 (Source: MSSQL_REPL_DB2, Error number: -204)

"

why sql want create his...

i configuring replications to DB2 and have errors when inserteing data:

error:

"Table1" ?BUF ?3 in *N not valid for operation. SQLSTATE: 55019, SQLCODE: -7008 (Source: MSSQL_REPL_DB2, Error number: -7008)

What is and...

we find answer;

MS SQL Server 2012 was installed on Win 2012R2, Oracle drivers not support this OS .

Support will be start from version 12.1.0.2. It is version not published...

up

Didn't anybody had migration from sql 2008 r2 to 2012 with oracle linked server?

Does have any thought?

i think , Logshipping is best option for you night create database copy and for reports.

and specifying question

How much data of databases? and How much data is changing?

i didn't undestand a bit, why you not use SSIS packages?

rename table and create new table with similar name 🙂

or create job for moving date