I have the following problem.
Locally I have BO Xi installed with MySQL as CMS, SQL server 2000 for the dashboard.
Now I have installed BO XI on a server. I made a backup of the SQL server database.
I want my CMS to connect with SQL server 2000, so I do not have to install MySQL again. how can I do this?
Is it possible to convert MYSQL to SQL server 2000?
please advise
Swimmer 
(BOB member since 2006-08-23)
First create the CMS on SQL server of the new XI installation done on server. This will create all the required repository tables.
Create a BIAR file using import wizard of CMS in MYSQL (local) and finally import it into the new CMS (SQL server )
hyder
haider 
(BOB member since 2005-07-18)
I have already installed BO XI on the server, and I thought I created CMS on SQL server, probably not see screenshot.
Can I check if I create a CMS on SQL server?
How can I create CMS again on SQL server? Do I have to installe BO XI again.
If I succeeded to create CMS on SQL server should I than install MHF and upgrade to Service Pack 2?
please advise again. I really appreciated your effort to help me
Swimmer 
(BOB member since 2006-08-23)
Since installation is already done for BO XI R2 on the server with repository DB as SQL server 2000, then go to SQL server Enterprise manager and check the repository schema for the tables (around 7 of them) created.
Now open import wizard and create BIAR file of the other CMS (on MYSQL)
Then use this BIAR file as a source to import into the CMS (on SQL server 2000).
Do this first and if everything is in place then you can install SP2
hyder
haider 
(BOB member since 2005-07-18)
I suppose the prefix of those tables starting cms??
I can not find those tables in my SQL server, very strange.
Swimmer (BOB member since 2006-08-23)
There is a utility that can move or recreate you repository in XI, save you worrying about biar files.
Go to the configuration tab of the cms service in the CCM.
Next to datasource name hit specify.
you should see 3 options, don’t have XI in front of me so can’t remember exact description, but one should say something like recreate and another move.
glenorchy 
(BOB member since 2005-11-10)
So finally I got my CMS started.
I find out that I didn’t create my CMS on my SQL Server.
I did the following to create CMS :
I selected CMS in the CCM, that I select the icon to change CMS-source and choose first option and connect it to the SQL database and tadaaa it works.
Now I still have to import all data with a biar file…to be continued
Swimmer (BOB member since 2006-08-23)