backup environment setup

[jeffinperth]

Hi all,
ebackoffice 7.2, efrontoffice
we have a production server, and a backup server. On both servers we have the databases
ebocontrol
eboconsol (a company db)
ebodata (a company db)
efo72 (a frontoffice db)

what i want to do is have another database on the backup server and set it up like

zebocontrol
zeboconsol (a company db)
zebodata (a company db)
zefo72 (a frontoffice db)

and be able to use sql backup to refresh our production server to the 'z' database on test server

I found a doc on the epicor answerbook that tells me how to do it if the two databases are the same name , but not when they have different names.
I have changed the zebocontrol tables smcomp,ewcomp,s2papprg and masterlst and the master table masterlst, but when i login to the backoffice zebocontrol/zebodata via the client, it doesn't matter which module i access, i get the error

Database error 916, server user xxxxx is not a valid user in database ebocontrol

I can only think that there is still a link somewhere pointing to the original control database . .

so - anyone have a cheat sheet that can help me out ?

all the best

jeff

 

[Flloyd]

Jeff,

While I can't help with the eFo stuff, I agree the issue(s) are probably related to column values referencing "old" db names and company id's.

I have a document for the eBo 7.0b product that identifies the objects that need to be changed to accomplish this.

I also have a couple of sp's to interrogate the db and find or find/replace strings (for the company name references), and identify the objects that refer to column names like company_db, company_id, or whatever.

Post an email address and I'll send this stuff along to you.

Any chance your working with CBI in Kwinana? Lloyd Freiday

 

[jeffinperth]

Hi Lloyd,
You could forward the doc to
jeffrey_newton@hotmail.com


No I don't work for CBI ( what is cbi, coopertaive bulk . . ) I work for a care group in Osborne Park, and what about yourself, you in Perth ?

cheers

jeff

 

[Flloyd]

Jeff,

Emailed the stuff to you...good luck. Lloyd Freiday

 

[alor]

hi jeff

i,m facing same problem of L lloyed can i get a copy of the e mailed stuff so i do my test enviroment

my e mail kambalayoub@hotmail.com

thanks ina dvance
alor

 

[jeffinperth]

Hi Alor,
I have been away from the office for a month hence I haven't been able to reply to your request.
I have now sent you the scripts provided by Lloyd.

regards

jeff