I have a dilemma. I have 20 branch offices that need to be able to
upload their unique copy of all their backend tables to a master
database at a corporate office. I really need only a copy of those new
records, deleted records , or changed records (but I guess exporting
all the data would not be a problem, not very big tables). Can I write
a query that updates the master database tables at corporate and have
that query launched on demand or using AutoExec when they open the
client frontends at the branches? The resulting corporate master
backend would have data currrent to whenever the various updates occur.
My only other thought is to have what at most will be 30 concurrnet
users accessing not "child" database backends, but the actual master
backend. The way I would in both cases have each branch see only their
data would be a branch identifying field which would, by query on this
field, load their unique data.....
Any pointers would help... Thanks Dave
1  1262 
Parasyke wrote:
I have a dilemma.
Yes, you do.
I have 20 branch offices that need to be able to
upload their unique copy of all their backend tables to a master
database at a corporate office. I really need only a copy of those new
records, deleted records , or changed records (but I guess exporting
all the data would not be a problem, not very big tables).
How would you send the data? Over a WAN where Corporate could connect
to the database or via an email?
Can I write
a query that updates the master database tables at corporate and have
that query launched on demand or using AutoExec when they open the
client frontends at the branches? The resulting corporate master
backend would have data currrent to whenever the various updates occur.
What is your delivery/update method/medium?
My only other thought is to have what at most will be 30 concurrnet
users accessing not "child" database backends, but the actual master
backend. The way I would in both cases have each branch see only their
data would be a branch identifying field which would, by query on this
field, load their unique data.....
Any pointers would help... Thanks Dave
There is replication. You might want to read up on it, see if that
would work.
Does corporate really need all of the detail, the nuts and bolts inside
each mdb or could it subsist on consolidated detail passed to it for
reports? I would think branches take care of detail, corporate takes
care of the overall picture...summa rized data.
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Moti |
last post by:
I have SQL server 2000 which recently crashed. I try to recover it and
found out that the Master database is corrupt. I never backup my
server using inline sql backup nor any third party backup program that
aware to SQL server. But I have full system backup of volume c on tape
(using NTBackup), which includes old version of Master database. My
questions are:
1. How can I recover this file into SQL server?
2. If so, it is not risky to...
|
by: Karim |
last post by:
I installed SQL Server, created a database for a sql server user and
noticed that the user has access to the master database even though the
checkbox for master database for the user login is not checked.
They can list sysusers and find out all the names. They can list all the
databases as well by using sp_helpdb.
Is this normal behavior?
If I check db_denydatareader and db_denydatawriter in the master database
for that user, will that...
|
by: Moti.Ba |
last post by:
Hello,
I need to restore the Master DB in my SQL 2k server (with sp3). The
problem is that i don't have SQL backups of this file I only have
general backup of the entire c:\ drive i made using NTBackup. So i
tried all I know and succesfully run the rebuildm utility. Now when I
try to restore it from the general backup (not SQL backup) using
"restore database master from gen_backup" i got error: "The file on
device 'gen_backup' is not a...
|
by: gdabbara |
last post by:
Hi,
We have a situation where we want to move our current database
server to a different hardware and rename the server.
If we change the Physical server name, do we have to go thru the whole
process of changing it in sql server by running sp_dropserver,
sp_addserver?
Can we have an alias for the server name in DNS and can sql server
resolve the server name internally by going thru DNS?
For eg: Our current database server name is...
|
by: Ray |
last post by:
Once a master database is moved to other location, it becomes a replica.
Can someone advise why it happens and how to change it back to master
database.
Thanks,
Ray
| | |
by: vonlinkerstain |
last post by:
Hi all,
I made a horrible thing this week. I have an script that delete all data from all user tables, and I run it in the master database.
After this I couldn't access the metadata from the tables of my databases using a JDBC connection.
My script runs over all sysobject that are different from dtproperties.
I don't have a back up of master table. I have tried to copy the data from another master database (from another machine) but I did...
|
by: brian.j.parker |
last post by:
I inherited an application (or two) that run on SQL Server 6.5, which I
haven't used in years, and am having a problem. I get the error:
------------------------------------------------------------------------
Can't allocate space for object 'Syslogs' in database 'master' because
the 'logsegment' segment is full. If you ran out of space in Syslogs,
dump the transaction log. Otherwise, use ALTER DATABASE or
sp_extendsegment to increase...
|
by: Parasyke |
last post by:
How can I, without using Replication technology, append a table in my
master database from data in another database? I have several field
offices with sales data that I want, on demand, to append up to my home
office Master database... any ideas? Thanks!!!! Dav
|
by: bensonissac |
last post by:
friends...i want to take a back up of full database..backend used is SQL
|
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: 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: 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: 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
| |
