I'd like to know what's the best practice in naming the
Here's the scenario.
There are 2 sales databases, one in US, one in UK. Both of
the databases will have identical structure.
There are 2 types of data stored in each database:
(1) user configuration
(2) sales information
Any user configuration made at any site will be replicated
to the remote site, meaning there will be a 2-way
For sales information, US and UK database will contain US
and UK sales respectively.
Shall I use the same database name, e.g. sales, for both
Or should I use different database name, e.g. us_sales and
If the sales data from both UK and US are to be replicated
into a third database, will there be any issues if I
maintain the same database name for both US and UK sites?
Thank you in advance.
Subject: Distributed Database Naming Convention
X-Mailer: WebNews to Mail Gateway v1.1t
Date: 30 Nov 2011 20:08:52 -0800
X-Trace: forums-1-dub 1322712532 10.22.241.41 (30 Nov 2011 20:08:52 -0800)
X-Original-Trace: 30 Nov 2011 20:08:52 -0800, 10.22.241.41
Xref: forums-1-dub sybase.public.ase.general:30730
Article PK: 73621