Re: DataBase reusability

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 08:56:28 +0200

W,Jordan
Are there any reasons to have two databases if as you said they have the
same table's structure?

use master
create table t(c1 varchar(50)) insert t values('master')
go
create proc sp_test as select * from t
GO
use northwind
create table t(c1 varchar(50)) insert t values('northwind')
use pubs
create table t(c1 varchar(50)) insert t values('pubs')
use pubs
exec sp_test --returns 'master'
use master
exec sp_MS_marksystemobject sp_test
use pubs
exec sp_test --returns 'pubs'
use northwind
exec sp_test --returns 'northwind'

"W. Jordan" <wmjordan@163.com.spam.proof> wrote in message
news:OUhzd6VHFHA.2936@TK2MSFTNGP15.phx.gbl...
> Hello,
>
> I am developing several database centric applications.
> Each application has gotten one or more databases. I
> discovered that some applications share some
> functionalities around database tables. For example,
> Application A will query the Members, Groups,
> MemberPreferences tables in database A, and Application
> B queries the Members, Groups, MemberPreferences tables
> in database B. Those tables named Members, Groups, and
> MemberPreferences have the identical table schema, and
> have the same select/insert/update/delete stored
> procedures, and triggers.
>
> Is there any good solution to maintain those kind of
> databases easily? Using the data import/export provided
> by the SQL Enterprise Manager might help a bit. Any
> other efficient alternatives to synchronize the table
> schema and stored procedures among those databases?
>
> W. Jordan
>
>

Relevant Pages

  • RE: Setup Distribution error 22538
    ... Use Master ... exec Sp_Addserver 'NewName', 'local' ... Also sp_dropserver for the distribution database. ... You might want to run sp_removedbreplication in the user databases but this ...
    (microsoft.public.sqlserver.replication)
  • Re: Scripts from internet making it working?
    ... > Hi my dream is to make databases and knowing how to make ... > upload a picture, and that come in one database an you ... > members can vote on pictures. ... This is a dream of me, ...
    (microsoft.public.access.developers.toolkitode)
  • Scripts from internet making it working?
    ... Hi my dream is to make databases and knowing how to make ... upload a picture, and that come in one database an you ... members can vote on pictures. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Passing of Monica Leonards
    ... Thinking of visiting your ancestral shtetls? ... It is with great sadness that the members of the Kupiskis SIG note the ... Her databases, for not only Kupiskis, ...
    (soc.genealogy.jewish)
  • Login/User/Role Audits
    ... Does anyone know an easy way to check to make sure all of the logins have permissions to all of the databases and are members of a certain role? ...
    (microsoft.public.sqlserver.security)