|
by: hd |
last post by:
Are there any standard approaches used to purge records from database
in merge replication senario ?
We are using merge replication between two sql server 2000 databases.
These databasess have differnt purging frequencies ( purging frequency
of subscriber database is 6 month where as that of publisher is year).
Is there anyway to purge data from subscriber and publisher without
getting these deletion reflected in replication ( basically...
|
by: smahler |
last post by:
Hi all,
Here is my situation.
I have an application that uses SQL 2000. The client has a program
that uses MSDE. The client MUST have the MSDE version of the Database.
What I have done is to create a SQL 2000 Database that is exactly like
the MSDE version. What I wish to do, is at regularly scheduled
intervals, update the SQL 2000 Data with the newest MSDE Data.
On my clients server, they have both MSDE and SQL 2000 installed
the...
|
by: Markus Enders |
last post by:
Hi everybody,
we are using version 7 of db2 and need to replicate a database. We are
using two web-based systems, which access two different databases. One
system is used for import data (internal usage), the other system is
used to show the imported data via web to the end-user (just reading the
database).
Both databases are running on different systems (both solaris).
Want we want to do is to replicate the import-database (source)...
|
by: Andrew Chanter |
last post by:
I developed 3 different replicated database applications in MS Access for 3
different corporate clients in Access 97 several years ago to enable data to
be shared across wide area networks. I observed 2 issues that plagued all 3
systems.
1. the database files continually became corrupt during synchronization.
Most times this was easily fixed via a repair and compact, but the frequency
with which this occurred was of concern, and...
|
by: WØCBF |
last post by:
I have an Access application that I wrote for a very specific business.
They now want to put a copy on a laptop and retain the application on
their PC. Then they want to modify data on both the laptop and PC then
merge the data together making the two copies of the same, for example
at the end of the business day. 99.9% of the time the same records
would not be changed. Is this possible in Access ???
Thanks
Chuck
|
|
by: rolandsun |
last post by:
we are designing a data collecting system, at each site we have a
database and have a central database,we will write data to site's
database, we want the site-database can publish
the data to central-database Asynchronously, how could we do that?
single replication sounds work,but it will replicate all update
,including delete ,we dont want that,we want only inserted data .
|
by: Asif |
last post by:
Hi all,
I am working on portal which is using MS Access 2003 database. The
problem that I am facing is that once I received data from vendors I
have to upload whole Access Database file to server.
Initially it is not an issue but after increasing the size of database
file(nearly to 50 MB) it is now difficult to upload such file on
server.
|
by: John Morgan |
last post by:
I have my first small SQl Server 2005 database developed on my local
server and I have also its equivalent as an online database.
I wish to update the local database (using and asp.net interface) and
then to upload the data (at least the amended data, but given the
small size all data should be no trouble) to the online database.
I think replication is the straight answer but I have no experience of
this and I am wondering what else...
|
by: aine_canby |
last post by:
Hi,
My company has an old access database which has been in use for many
years now by a few employees. I need to make some design changes to
one of the forms, but I'm not sure how I should go about doing this. I
have designed databases with access before, but not when replication
was used.
So, should I first get everyone out of the database, then make a copy
of the database to which I will add my changes to. Then finally,
|
by: Query Builder |
last post by:
Hi,
I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server
Because of an unfortunate scenario, I had to restore one of the
publication databases. I scripted the replication module and dropped
the publication first. Then did a full restore.
When I try to set up the replication thru the script, it created the
|
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: 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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|