Has anybody had any experience migrating a BizTalk 2006 server from a SQL 2000 server to a SQL 2005 Server? I understand that nothing changes as far as the content of the databases - views, stored procs, etc. all remain the same. The scheduled jobs have to be migrated. All of that aside... tips, trick, etc.
I'd start with "Moving BizTalk Server Databases" in the BizTalk documentation