Hi.
On your BizTalk Server the is under All Programs -> Microsoft BizTalk Server 2009 a program called BizTalk Server Configuration. This you should use to unconfigure and re-configur with the datas to the new SQL Server. The only thing I don’t know is what will be if you use the BAM Tools. Because of the Application Pools in IIS.
First I would save the configuration with the BizTalk Server Confugartion.
Second I would unconfigure with the BizTalk Server Configuration.
Third re-configure Biztalk again with the new database links (you should have build the new groups etc.)
But as I said before – I did’t know if you will go back and for the new configuration what will be with the IIS AppPools for BAM. But the connection to the new SQL is going smooth…
I hope this ok for you.
Wolfgang