Many enterprises need to move files to an alternate location as soon as they arrive on the server. To make this process more efficient, create a Move Files event and employ a batch script.
However, there are considerations for using this method. Depending on your organization's needs and hardware resources, you may need to balance your configuration to use resources carefully.
i will move only the ms sql database (it is only one freeware "MS SQL Express 2009), but i will move it to one another server (that have licensed MS SQL enterprise database environment). The application, and the ftp shared folders will be rested on original server.
How can i complete it?
i have one step-by step scenario, but i dont know, that is it god or not:
Version is as follows: Cornerstone MFT 64 bit (on windows 2012 server) Version 10.41 Build 1833
STEP1 create snapshot from appserver
STEP2 stop application on cornerstone appserver
STEP3 Perform Full Backup from local MSSQL database on original appserver.
save this db-backup, move it into remote new database server.
STEP4 Steps to uninstall/apply the Software Corenerstone on application server
STEP5 Reboot system on application server
STEP6 Perform Restore the moved MSSQL database on remote database server (new database server)
STEP7 Steps to install/apply the Software Corenerstone
step by step installation wizard with remote database settings
STEP8 Reboot system on app. server
STEP09 Start new installed Cornerstone software on original application-server with remote database-connection.
STEP10 Fulltest with user
Please let me know, that it works or not...