Hi, Folks.
I got a scenario that cause me headache.
Currently our company is using an AS/400 Server which run DB2 to hold all critical data(I called it remote site). I dont' have acess to this database. My local site use SQL Server. SQL Server uses DTS to transfer data from DB2 to its local database.
Because of design issue, DB2 has 2 tables to contain the item information (like name, brand, categories), and SQL Server only has one. To keep the data most updated(DTS only runs twice a day), whenever a person add an item in DB2, he/she has to inform people in local site to manually add an item to SQL Server, too. Now i want to automate this process, or at least make it more trackable, because the person who add in DB2 might forget to inform the person to add in SQL Server.
I came up with two solutions:
1. Create trigger in DB2, then whenever a new item is added, DB2 will send an email message to the person who are responsible to add items to SQL Server with relevant information.
2. Design a new DTS package in SQL Server, keep track of the change of 2 tables in DB2.
For the first solution, I'm not familiar with DB2, and I posted my questions in DB2 forum here. But there is no response yet. Also, it would be costly since i don't have access to DB2 and need to pay someone else to do this for me. For the second solution, the DTS has to be run quite frequently (which i think may not be a good way) since i don't know when the person in remote site will add item in DB2, and I really need this info most recent updated.
Could anyone tell me which solution i should go or is there any better solution? Sorry for the long post, i'm looking forward to any of your suggestions.
Ben
2  2204  almaz 168
Recognized Expert New Member
General thoughts:
You'll still have to choose between time and money :).
I mean that you cannot get immediate notification about the changes on remote site unless it will inform you in some way, so if you want to be informed as fast as possible - you'll have to alter remote site. Less reaction time, more money.
OR you may setup a SQL Server job that will on periodic basis check the remote site for changes
try using MS SQL Server - snapshot replication
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Rob Meade |
last post by:
Hi all,
At work we have 2 servers in a cluster for our web apps.
One problem we have experienced (along with many others!) - is that if a
user is logged into one of the applications on server a for example and it
goes offline or fails their session is lost also - even though the
application becomes available on server b.
I have heard that it is possible to either exchange the sessions between
|
by: Rupe |
last post by:
I have a web site on a remote, shared host with a bunch of individual
Access databases. I want to switch my databases from Access to MS SQL
and have some questions.
I update some of my Access databases through web-based content
management systems. Other databases I update locally (through a bunch
of Access forms) and FTP them periodically to my web site.
I want to be able to switch my databases over to SQL, store them on a
remote...
|
by: markydev |
last post by:
Hi,
I'm using sql server 2000 sp4.
I've 2 databases linked, an instance and my local.
I'm getting two different errors when trying to update the remote table
(local server) from the instance.
There is only one row of data in the table with an identity field.
1st sql:-
UPDATE ..dbo.NUMBERS SET =3
|
by: banz |
last post by:
Hello
I have a problem to resolve: I wrote a Perlscript which caches data from a
server (local on my machine) I would like to have a other connection to a
remote server but I don't know how to define the servername / hostname in
my Perl Progrem..
Here is the code:
|
by: Ken Allen |
last post by:
I am relatively new to .Net and C#, but I hav ebeen programing in other
languages and done some COM work for a number of years. I am attempting to
understand how to map an older program architecture into .Net -- not looking
to do it at this time, just to understand how I would achieve it.
In the old environment, we had two classes, a client and a server class,
that managed a data object. The server object knew how to interface with the...
| | |
by: John |
last post by:
Do you guys have any idea if web hosting companies usually give access to
SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous provider and
now the more I am looking into offers on the net the less I can see this
feature specified.
What can I do without EE to backup my database in a completely automated
way? Can I assume SQLDMO will always be available so that I can backup the...
|
by: dbuchanan52 |
last post by:
Hello,
I am building an application for Windows Forms using. I am new to SQL
Server 'Views'. Are the following correct understanding of their use?
1.) I believe a view can be referenced in a stored procedure something
like this;
Select * from View1
Is that true?
|
by: l3vi |
last post by:
I have a new system Im building that stores entries of what people are
searching for on my sites.
I want to be able to keep records of how many times a keyword was
searched for daily, and from that I can calculate weekly and monthly.
At this point I have one entry per search phrase with the number of
hits the search phrase has gotten, and the last time it was updated.
As I start to take the program out of testing and move in more...
|
by: graphicssl |
last post by:
Okay, so first of all, I'm a designer first and a light coder second (I'm only really trained with HTML and CSS). So I apologize for having to post about something that's probably super-trivial!
I'm working on setting up a shopping cart for a one-product web site, and I'm using HTML and CSS, with ASP for the shopping cart. The ASP takes the information from the form on the shopping cart, and formats it in to two e-mails: one for the company...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
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...
| |
