Moving Repository Databases from SQL Server 2005 to 2008?

[#1]

Does anyone have a reference to documentation that explains the process/best practice for moving Data Services 3.2 (12.2.2.3) Repository Databases from one SQL Server to another?  We are moving all of our SQL Server 2005 databases to a new SQL Server 2008 database.  I was hoping to find a step by step process for changing connections within my Data Services environment.

• Central Repository
• Local Repository on Job Server
• Local Repositories for individual users

Thanks

Tammy Datri

Applications Manager

Grane Healthcare

[DayaJha]

Hi Tammy,

Please see the below steps for Configuration of Profile Server in SAP Business Objects Data Integrator, So the Images are same in SAP Business Objects Data Services Edge Application 3.1.

Step 1: Setup a Data Profile Repository for that Create a new Data Profile Repository

Create the New Data Base for Data_Profile

Step 2: Go to Start->Program->Business Objects 11.5-> Repository Manager

Step 3: After Execute it will give you

Step 4: Then go to Server Manager and setup for Data_Profile for Job Server

Step 5:  Then go to Administrator and add that Data_Profile to Repository

Then Test & Apply

Step 6: Then it will show in your Repository add Profile Job Server

Step 7: Then Create User for Login as Profiler in Data Integrator Job Execution Add Data Profile to a User

Then go to User

And Put the Following Details User Name: Daya, Password: ****, Confirm Password: ****, Display Name: Daya, Role: Profile User, Status: Active, Profile_Repository: Data_Profile

Step 8: Then Logout and Login with UserID: Daya Password: ****

Step 9: Here Data Profile repositories is Created

Step 10: Then Go to Development Server and Start the Profile

Step 11: Then Go to Tools Profile Server Login

 

Step 12: Put the Details Host: BI4SERVER/LocalHost, Port No: Default, UserName: Daya, Password: ****

Step 13: Then Profile Server Is Start

Hope this will help you as well.

Thanks,

Daya

[tammy_datri]

Just wanted to follow up to let you know that I talked with someone at SAP support yesterday and we had to update the AL_Machine_Info table in the profiler repository database.to point to the new database server.  For some reason The Data Services Server Manager does not always update this table.  I see that some of the databases for the local repositories have an entry for the new server and some don't.  Might be a bug in the version I am running.

Once I ran this script, I was able to submit the column profile request successfully.

UPDATE [BUSOBJ_DS_PROFILER_REPOSITORY].[dbo].[AL_MACHINE_INFO]

   SET [RESERVED2] = '<new servername>_BUSOBJ_DS_PROFILER_REPOSITORY_'

Thanks for all of your help and support on this problem.

Tammy