Hi,
We are going to be running two SQL Server 2000's from the same
physical server, with Windows Server 2003, and I need to have certain
tables between them syncronized. Database A is a backend to a website and
database B is going to be used by a different department. Both the
databases have certain data in common but it isn't stored in the same
format. I can't just auto sync one with the other, the data (records) has
to be manipulated before updates between them can take place.
So, what I need to do is convert certain data when A is updated and tranfer
that to B and vice-versa, in real-time. I've looked at Snapshot, that
isn't an option. I imagine some kind of Event Driven API is needed, where
do i being?
TIA 4 1407
"someguy" <in*********@yahoo.com> wrote in message
news:Xn*********************************@216.196.9 7.142... Hi,
We are going to be running two SQL Server 2000's from the same physical server, with Windows Server 2003, and I need to have certain tables between them syncronized. Database A is a backend to a website and database B is going to be used by a different department. Both the databases have certain data in common but it isn't stored in the same format. I can't just auto sync one with the other, the data (records) has to be manipulated before updates between them can take place.
So, what I need to do is convert certain data when A is updated and tranfer that to B and vice-versa, in real-time. I've looked at Snapshot, that isn't an option. I imagine some kind of Event Driven API is needed, where do i being?
TIA
Have you considered replication? It sounds as if transactional replication
may be what you need, there's plenty of information in Books Online, and
there's also a newsgroup for replication -
microsoft.public.sqlserver.replication.
Simon
"Simon Hayes" <sq*@hayes.ch> wrote in news:42**********@news.bluewin.ch: Thanks Simone. Any books/online tutorial you would recommend? "someguy" <in*********@yahoo.com> wrote in message news:Xn*********************************@216.196.9 7.142... Hi,
We are going to be running two SQL Server 2000's from the same physical server, with Windows Server 2003, and I need to have certain tables between them syncronized. Database A is a backend to a website and database B is going to be used by a different department. Both the databases have certain data in common but it isn't stored in the same format. I can't just auto sync one with the other, the data (records) has to be manipulated before updates between them can take place.
So, what I need to do is convert certain data when A is updated and tranfer that to B and vice-versa, in real-time. I've looked at Snapshot, that isn't an option. I imagine some kind of Event Driven API is needed, where do i being?
TIA
Have you considered replication? It sounds as if transactional replication may be what you need, there's plenty of information in Books Online, and there's also a newsgroup for replication - microsoft.public.sqlserver.replication.
Simon
"someguy" <in*********@yahoo.com> wrote in message
news:Xn********************************@216.196.97 .142... "Simon Hayes" <sq*@hayes.ch> wrote in news:42**********@news.bluewin.ch:
Thanks Simone. Any books/online tutorial you would recommend?
<snip>
As always with MSSQL, read through the relevant Books Online sections first;
next, set up a simple replication scenario and play around with it. By the
time you've done that, you'll have a better understanding of what you need
to know, and you'll be able to use sources like microsoft.com, Google and
newsgroups more efficiently.
I don't have much experience of replication myself, so if you feel you need
more detailed help on finding good information sources, then I would suggest
asking in the replication newsgroup. But I strongly suggest you read through
the Books Online information first, or else people will just refer you back
to it anyway.
Simon
Simon Hayes (sq*@hayes.ch) writes: "someguy" <in*********@yahoo.com> wrote in message news:Xn*********************************@216.196.9 7.142... We are going to be running two SQL Server 2000's from the same physical server, with Windows Server 2003, and I need to have certain tables between them syncronized. Database A is a backend to a website and database B is going to be used by a different department. Both the databases have certain data in common but it isn't stored in the same format. I can't just auto sync one with the other, the data (records) has to be manipulated before updates between them can take place.
So, what I need to do is convert certain data when A is updated and tranfer that to B and vice-versa, in real-time. I've looked at Snapshot, that isn't an option. I imagine some kind of Event Driven API is needed, where do i being?
Have you considered replication? It sounds as if transactional replication may be what you need, there's plenty of information in Books Online, and there's also a newsgroup for replication - microsoft.public.sqlserver.replication.
Transactional replication certainly could be a possibility. But it seems
that the two databases have differnt layout. Replication is normally used
between identical databases. I believe that there are hooks in replication
to permit you to deviate from the pattern, but if there is to be trans-
formatation on a greater scale, the solution can be very complex.
An alternative would be to have triggers that writes data to events
table, and then you have a job running from SQL Server Agent that
pick up the events and relays them to the other server. With the very
brief information given here, I would rather investigate such a
solution, before I tried replication. (But then again, I haven't looked
at replication since 1998, and that was 6.5.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bob |
last post by:
I have been asked to modify an existing Access database so that it can
update a MySQL databse in head office from multiple MS Access databases in
branches. The idea is that when the HO database is...
|
by: Ericson Smith |
last post by:
Hello everyone,
Take the query below:
select *,xmin from settings where xmin > '187167023'::xid limit 5;
Although the docs say this is a 32 bit datatype, I have casted the
integer...
|
by: mantrid |
last post by:
Im using arrays generated from my records displayed in a table on my site to
update the corresponding records in a mysql database ie
on the web page
col1 col2 col3
1 2 2
1 ...
|
by: Senthil |
last post by:
Hi All
We are having a VB application on SQL. But we need to collect
information from persons who will be offline to verify data and insert
new data. Generally they will be entering the data in...
|
by: Benzine |
last post by:
I recently rolled out replication on our production server (MS SQL 2000
SP4) and every time a subscriber tries to sync the following always
appears in the Merge Agent History:
"Downloaded 100...
|
by: Denis |
last post by:
Hello,
does anyone know of an easy way to do a Bi-Directional Data Sync
between SQL Server and an Access database.
I want to make sure that both Access (on a desktop app) and SQL Server
(on...
|
by: goralondos |
last post by:
Hopefully this is the right forum, it didn't seem to quite fit into any of the others.
My company has 20 remote sites that backup date to our main building.
Presently, a scheduled batch job is...
|
by: Dave |
last post by:
I have a global.asax file with Application_Start defined and create some
static data there and in another module used in the asp.net application and
I realize that static data is shared amongst...
|
by: kirk |
last post by:
I have program.cs, my "main" form and then a "settings" form.
My "main" form existed for awhile and I had constants, instantiations,
properties, etc within it created.
I went to create my...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
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...
|
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...
|
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...
| |