Reatore SQL backup to a different databse name

[ZABARVAN]

HI

I tried to restore SQL backup into a different database name other than the original database. While running ACCPAC it is giving error as : database profile refers to a database which was created with database ID RRRDAT" (original name).

Can we change this original name to a new name as we need it for Data Analysis.

Which Table can be edited.

Any help please

Thanking You

ZAb

 

[ettienne]

Edit CSCOM and change the ORGID

 

[ettienne]

The ORGID must match the database ID for the new company you created.... if that makes sense

 

[ZABARVAN]

Thank you o much...

 

[DjangMan]

Quick TSQL script for MSSQL databases:

declare @NewOrgID as varchar(6)
select @NewOrgID = 'XYZDAT'
update CSCOM set ORGID = @NewOrgID 
update GL01 set COMPANYID=@NewOrgID

 

[Jay Converse]

FWIW, I've never bothered with GL01, and never gotten any errors, so I just UPDATE CSCOM SET ORGID = 'XYZDAT'

 

[ettienne]

Same here, GL01 does not seem to play any part.

 

[DjangMan]

I just know that I hit a problem one year and fixing that field got me past the problem.

 

[ettienne]

That's possible D-Man, I would never use a copy of a database like this in a production environment. Let's just say I have not run into any issues simply because I have not tested every possible transaction.

 

[Jay Converse]

I vaguely remember a Crystal report years ago that joined to GLO1

 

[ramam1]

When I clone a DB into a new DB + company for testing I always update:
companySYS and companyDAT: CompanyID in CSAUTH, CSUSCST
companyDAT: COName and OrgID in in CSCOM

Never noticed GL01.CompanyID before, thanks DjangMan!

 

[Jay Converse]

On the subject of the CSxxxx tables, for non-technical users who Dbdump/Dbload instead of SQL copy, the ORGIDs aren't correct after a load. If you don't want to do SQL updates to fix them, run Database Setup, edit the System database, and do a propagate.

 

[ettienne]

There is/was some reports that linked AUDTORG back to the CSCOM.ORGID field and if they did not match then the reports would not print any data.

 

[ZABARVAN]

Thank you all guys.....