Want to upgrade database

Usage and Config Platform
1

(imported topic written by krupakiranad91)

hi,

i want to upgrade my bigfix database from MSDE 2000 to SQL server 2005 enterprise edition. but its not supported. is there any other way so that i can use SQL server 2005 enterprise edition as my database server on the same server. because we are planning to host one more application on the same server. can anyone please help me to sort out this problem.

regards,

krupa

2

(imported comment written by BenKus)

Hi Krupa,

I honestly don’t know how to upgrade MSDE 2000 to SQL Server 2005, but I imagine there are instructions somewhere on the Internet. You might need to backup your database, uninstall MSDE, install SQL Server, and then restore the database (but I have never tried this myself).

Note that we recommend that you don’t share the BES Server with other applications because of performance concerns (both from BES interfering with other applications and vice versa).

Ben

3

(imported comment written by krupakiranad91)

hi Ben,

thanks for the reply, please let me know how do we point our bigfix to the new database which resides in another server.

regards,

krupa

4

(imported comment written by BenKus)

hi krupa,

You need to point your ODBC DSN “bes_bfenterprise” to the new server and make sure that your components have privileges to log into the remote database.

Perhaps the easiest thing to do will be to uninstall the BES Server component and reinstall it with the “remote database” option.

Ben

5

(imported comment written by krupakiranad91)

thank you Ben,

let try this option and let you know.

regards,

krupa