In this article we will explain how to migrate or move BizTalk databases from one server to another server. Let’s assume we want to move our BizTalk primary databases from local server to remote server or any other server on the network. Same method can also be used to move databases to SQL server cluster.
· You should have admin user account access to both server, source and destination server.
· You should have basic knowledge of SQL Server.
· You should have basic knowledge of configuring BizTalk Server.
Step by step procedure
There are few major steps to follow which are described below. We will also explain these steps in detail in later.
1. Stop all BizTalk server services.
a. Perform a partial stop of all BizTalk services, do not perform a full stop!
b. Stop all host instances.
c. Stop BizTalk server services.
ii. Enterprise Single Sign-On Service
iii. Rule Engine Update Service
iv. Any other BizTalk service that is running
2. Stop the SQL Server Agent service.
3. Stop IIS.
4. Backup following BizTalk databases using Backup BizTalk Server job.
For configuring Backup BizTalk Server job please follow instructions mentioned at https://msdn.microsoft.com/en-us/library/aa546765.aspx
you may need to run sp_ForceFullBackup before running the job.
5. Restore above backup databases on the remote server. – NOTE: do not use simple restore task, use cs script method instead.
Open SQL server management studio and restore all the backed up databases. In the SampleUpdateInfo.xml file, comment out all of the databases except for those you have moved to the new server. Edit C:\Program Files\Microsoft BizTalk Server 2006\Schema\Restore\SampleUpdateInfo.xml
a. Do a “Replace All” and change SourceServer to ….
b. Do a “Replace All” and change DestinationServer to ….
Copy the edited SampleUpdateInfo.xml file to the following folder, open a command prompt, and go to computer: %SystemDrive%\Program Files (x86)\Microsoft BizTalk Server <version>\Bins32\Schema\Restore and run
cscript UpdateDatabase.vbs SampleUpdateInfo.xml
Copy the edited SampleUpdateInfo.xml file to the following folder computer: Copy to %SystemDrive%\Program Files (x86)\Microsoft BizTalk Server <version>\Bins32\Schema\Restore open a command prompt, and go to computer: %SystemDrive%Program Files (x86)Microsoft BizTalk Server <version>Bins32SchemaRestore and run
cscript UpdateRegistry.vbs SampleUpdateInfo.xml
6. Script all SQL server users from source server and run those script on destination server.
7. Script all SQL server agent jobs from source server and run those script on destination server.
8. Restart Windows Management Instrumentation service under services from services.msc
9. Re configure BizTalk server administrator
a. Remove current BizTalk group
b. Connect to existing group
c. Configure destination SQL server by giving server name
d. Configuring databases
Your BizTalk Server databases is now moved or migrated to another database server and BizTalk should be running properly.
Feel free to contact in case of any query