Open SQL Server Management Studio and login with valid credentials and expand Databases node in the left panel To start the database migration process we have to create an empty database on target SQL Express server. Migrate the content of data store to a new database. This command will not work when you try to backup database located on remote server hosting SQL Server Express and will not return and error message as it is shown below: Please note that dsmaint backup must be run on the XenApp 6.x server hosting the SQL Server Express data store. The command dsmaint with parameter backup” makes a copy of the MF20.mdf SQL Server Express data store to the specified location. Please remember that starting from XenApp 6 MS Access is no longer supported and dsmaint backup command can be used to perform the backup of data store hosted on SQL Server Express.įrom the command prompt the following command is executed: Important note: In many posts or articles you can find an information that dsmaint command can be used to backup only data store stored in MS Access database. The XenApp Server DSMAINT Reference contains syntax and use details. To preform the backup we will use dsmain command. It is a best practice to always backup the XenApp database before performing any operation on data store.
When XenApp Server Role Manager is used to install SQL Express a standard configuration is used and database engine is configured with the following settings: Take a backup of your exisiting datastore. On remaining servers create a new file dsn pointing to the new SQL server.Create new dsn file pointing to the new SQL server.Migrate the content of data store to a new database.Take a backup of your exisiting datastore.SQL management studio will be used only in order to create a empty database on new SQL server and assign user name and permission to the database.
To perform a migration we will use dsmaint command. In this scenario we will migrate a data store located on server XA03 to a new database located on SQL Express installed on server XD01.
In this article we will explain how to move a datastore to a new SQL server using 3 different set of tools. Migration of XenApp data store to a new SQL server can be done using different scenarios.