Move CE90 database

[dpm1234]

I have Crystal Enterprise 9.0 installed on server1 (Windows 2000/MS SQL2000). I created server 2 (Windows 2000/MS SQL2000) and would like to move the CE90 database from Server 1 to Server 2, and then decomission server1.

I need an exact copy, w/ object ids the same, etc... Import doesn't do the job. I tried backing up CE90 and then restoring it on server 2, but that doesn't work. The services fail to start. I see that the server name is coded in the tables.

Can anyone give me a procedure to move the CE90 database from server1 to server2??

Thanks in advance...

 

[bessebo]

It looks like you did not get a reply to this question. Did you resolve it because I need to do the same thing.

Regards,
Bessebo

 

[pgtek]

Hi
check this thread

thread183-17349

cheers



pgtek

 

[pgtek]

hi
also check this link

http://support.businessobjects.com/...ndexq2=&indexq3=&indexq4=&btnG.x=25&btnG.y=14

cheers


pgtek