DTS incremental IBM to SQL server 2008
Well what happens
is I have
to replicate
an
IBM DB2
database
to a
SQL server
2008
database.
The problem
is that I can
replicate the
data
normally, but
I can't create
incremental loads
of
updates or
changes
made in the
IBM
database.
I have no
permission to
make any changes
to
IBM,
so I have
to
do with
DTS
in SQL server.
I need a
immediate
replication...
Help please
...!!
March 24th, 2011 12:44am
You can pull data from DB2 onto staging database on SQL 2008 - then from staging you can push data to actual tables.
Pulling data from DB2
1.Create a linked server connection between SQL 2008 to DB2
http://support.microsoft.com/kb/222937. using openquery (http://msdn.microsoft.com/en-us/library/ms188427.aspx) you can pull the data(full / incremental) across to
staging
2. Design SSIS packages to pull across to staging.
Pushing from staging to Main database
For this you can either use T-SQL scripts (Merge)
http://technet.microsoft.com/en-us/library/bb510625.aspx or SSIS packages to refresh main databases.
Free Windows Admin Tool Kit Click here and download it now
March 24th, 2011 1:36am
thank you so much!!!.. it works:.....
March 30th, 2011 4:46pm