You would have to setup the new db and appservers and then export/import objects from the 2 installs. There's no supported way to swap databases out.
The appserver can run on a linux system and the db can still be MSSQL. You would only have to use a windows box for the bsara server, as it must have the database thick client on it.
Many thanks, that's a superb answer. To confirm we can leave the SQL server 2005 running on Windows and have the App Server running on SUSE Linux Enterprise Server?
Customer Solution Architect
Design Centre, Core Services
SOL10, Fujitsu Services, 51 Homer Road, Solihull, West Midlands, B91 3QJ
Mob: +44 (0) 7867 830914
Fujitsu Services Limited, Registered in England no 96056, Registered Office: 22 Baker Street, London, W1U
This e-mail is only for the use of its intended recipient. Its contents are subject to a duty of confidence and may be privileged. Fujitsu Services does not guarantee that this e-mail has not been intercepted and amended or that it is virus-free.
I talked about this internally a little. Officially, and according to here:
We don't officially support the linux -> mssql configuration. It's not a common configuration so it has not been through the same testing that the windows -> mssql/oracle and unix -> oracle. However, we do have customers running in this configuration and the product is functioning normally. I was a a customer a couple weeks ago running rhel 5 appservers, a mssql db and a windows box for bsara.
If you need this to be officially supported, I suggest you go through your BMC account rep and have them raise the issue to our product managers. Technically I don't see why this would be an issue as it's kind of the point of jdbc.