Hi folks,
I'm totally not familiar with DB2 databases, but for a project at work
I need to synchronize a MS SQL database with a DB2 database. The MS SQL
server is (offcourse) on a Windows 2003 server, while the DB2 database
is on a non-windows environment.
Now I wonder what is the best way to accomplish
synchronisation/replication? Is there a built-in tool to do this, will
I need third party software, or will I need to write my own
synchronization application (there is a log table which keeps track of
all changes made to any record)?
I know there is the db2 load or import command. Is it possible to
invoke that command from a C# application with the DB2 .Net Data
Provider or any other data provider?
Thanks in advance!
--
Tjeez
Message posted via http://www.exforsys.com for all your training needs. 6  6502 
I do not know which is bestm but IIRC, SQL Server comes with DTS
Packages that should make this pretty easy.
B.
Brian Tkatch Wrote: I do not know which is bestm but IIRC, SQL Server comes with DTS
Packages that should make this pretty easy.
B.
Thanks for your reply. But I'm not sure how to do this with a DTS. Is
it not impossible to connect to DB2 (non-Windows) from MS SQL Server?
I was thinking to retrieve all changed records (per table), put them in
a delimited file and then use the db2import command tool (with
'INSERT_UPDATE' as a parameter) for each file to 'synchronize' the DB2
database. The only thing I don't know is how to specify records that
must be deleted (other than using a regular SQL statement).
I also must consider buying a third software application to do this. I
must check which is better to maintain, which is cheaper, which is
best, ...
--
Tjeez
Message posted via http://www.exforsys.com for all your training needs.
> But I'm not sure how to do this with a DTS.
Create an ODBC connection to DB2, then in DTS add the object for each
database and use an action run a SQL statement. Or something like that,
i haven't done it in a while. Is it not impossible to connect to DB2 (non-Windows) from MS SQL Server?
Isn't that what ODBC is for?
I was thinking to retrieve all changed records (per table), put them in
a delimited file and then use the db2import command tool (with
'INSERT_UPDATE ' as a parameter) for each file to 'synchronize' the DB2
database. The only thing I don't know is how to specify records that
must be deleted (other than using a regular SQL statement).
Hmm.. good question. I don't know the best way.
B.
You can use DB2 built-in replication software, but that would need an
additional license for Information Integrator.
Then DB2 would take care of the changes and apply and purge them. It
would accomplish that using so called 'change data'-tables. Those would
be filled asynchronously reading the log files in DB2 and using
triggers in SQL server.
I dunno MS solutions - I am sure there is something on this side as
well - to accomplish that or any other third-party product.
If you write it on your own, you have to take care of all that
yourself. Whether that is useful depends very much on the complexity of
the data you want to replicate; and whether you need too keep
informations about transactions (e.g. OLTP) or just want to copy some
data. For loading some data into a (small) DWH an own solution using
triggers or just coying data might be cheaper.
Thanks for your replies! I will take a look at both DTS and Information
Integrator.
--
Tjeez
Message posted via http://www.exforsys.com for all your training needs. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Phil Matish, MCSE |
last post by:
I have an Access database that I use frequently. Often, I take it to
a home PC, or laptop to work on at night. The next day, I overwrite
the old one with the one I have been working on.
The only problem is - during this time, others may want to add records
at the office. This causes an obvious data loss problem if I
overwrite their edition of the database.
Is there a way to synchronize the database? If someone made additions
at...
|
by: Rick |
last post by:
I'm running an Access2000 front end mde linked to an Access2000 back
end mdb. I need to set up replication and synchronization of only the
data tables between the master db on the pc and replicas on numerous
laptops.
I know that it can be done using the Access replication manager
(although without a simple UI in the front end mde), but the question
is:
If I link the FE to MSDE rather to Access, can I 1.) provide a more
|
by: Alphonse Giambrone |
last post by:
I am not sure if these are the correct groups to post this, so please
redirect me if there are better ones.
Client has a SQL Server db of organizations and member info that is in
pretty much constant use at his location.
He would like to make the maintenance of adding/editing member info
available on the web.
Since the data contains personal info the web app (built in ASP.NET) will
use SSL.
The unique identifier for a member is the...
|
by: jodyblau |
last post by:
I'm fairly new to access, so I hope this question isn't too elementary.
I'm putting together a database for my office. I want the database to
be accessible to 5 or 6 users on our network and so itt may be used by
more than one person at the same time.
I am hoping that someone can give me an idea of some of my options in
facilitating this. My instinct, from fishing around in the database
options, is that it might have something to do...
|
by: MAILTONRK |
last post by:
Hi,
I am a Mainframe guy. I am working with MS access(maintaining a
application) for the last 2 weeks.
I had one master database and four replicas. One of my replica had
trouble in synchronization(It said, database is in use..). After
searching google, I ran "Compact and repair" utlity against my replica.
It looks like, it has changed the attribute of my replica.
| | |
by: prashant |
last post by:
Hi,
I am doing transactional replication with queued updation from
subscribers.
I have synchronized database at both the ends. If I chose 'No I have
data and schema at Subscriber' option while subscribing to the
publisher and if I try to update the subscriber, I am not able to see
the updates at the both ends.
Do I need to run any scripts in order to inform the synchronisation
agent that I have synchronized at both the ends and...
|
by: JA |
last post by:
Hi,
Is it possible to make changes to an Access 2000 database on my desktop, and
have it update those changes to SQL Server 2000 on the web?
I have to update stock and prices every night. Right now I am using Access
2000, and I just make the changes, and then upload the changed db to the
server, and overwrite the old db.
But I am going to be using SQL Server 2000 soon, and I know you don't just
|
by: Veggis |
last post by:
Hi
We have this access application - which we use to register stuff into.
Most of the time we're online, and that's all right, but now we need
be able to register stuff offline, and then it would be nice if we
could copy the registered stuff into the main database when we get
online.
So basically I want to copy data from one mdb-file to another - and
these two mdb's look the same in design, but have different data. I
|
by: javelin |
last post by:
Can someone recommend a utility (preferably open-source) to
synchronize changes across servers? I need to bring only data over in
some cases, and only objects in other cases. Any ideas?
Thx!
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
