How to Manager Several DataBase with same Name

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to Manager Several DataBase with same Name

Author

Topic

CLages
Posting Yak Master

116 Posts

Posted - 2005-10-08 : 11:04:35

Hi folks

I have a System working fine, evething is ok.
The connection is thru ODBC
the name of Database is DEC
This System is running in 15 Clients (15 differents Companies)

Inside de Source Code i Have always
SELECT * FROM Dec.Dbo.Tablex or
DELETE FROM Dec.Dbo.Tablex or
UPDATE Dec.Dbo.Tablex

Some time one of this Clients Reports some Erros or
he wants change something

Then in my Computer I have to do
1 - Detach a Dababase i am using whose name is DEC too
2 - Attach the Database of this Clients (Name DEC)
3 - I check what he wants

if I have to Support other Client i have to do the samething again

the question is

How can i have attached all Clients Database, using the same Source Code?

one of option i found is change my source Code to
SELECT * FROM Dbo.Tablex (without Database Name)
and i will use a Database name that is in ODBC configuration.

Tks

C. Lages
From Rio de Janeiro

Kristen
Test

22859 Posts

Posted - 2005-10-09 : 03:34:22

Would

USE MyDatabaseName
SELECT * FROM Dbo.Tablex

be of any use to you?

Kristen

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-10-10 : 18:38:05

If you go with Kristen's approach, then, rather than detaching and attaching all these databases, you can just RESTORE your clients database to a different database name on your system while working on it.

---------------------------
EmeraldCityDomains.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources