Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sys Datafile copy

Status
Not open for further replies.

guyinstyle

IS-IT--Management
Aug 26, 2012
31
AU
Dear all gurus,

I have around 10 companies so as 10 databases as well.
The guy who created these databases also created 10 different system files as well. This will give us some hard time when we add new group or security so we need to create the same in each database.

Can some one help me to sync all my sys files into one consolidate sys file? and later how i will map with all my databases as well.
Is it really helps me to sync user securities and authorizations?
Is it a right way to do so Or i can leave this thing as is?

Many thanks.
 
He was stupid. You only need one system database. You can't sync them, you'll need to do the dirty work to put the authorizations together.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top