Hi,
I need to move the databases created by CSF to a different SQL Server Instance.
Where and what will be the changes required to be done to get the system running again.
Ashish
I think you can use the CSF configuration files to map for the new SQL Server Instance if the CSF Database structure and data was not modified.
Regards,
What is meant by "CSF Database structure and data was not modified"
We havent modified the schema of the databases.
But whats the "data" being referred in the above statement?
Ashish
Hi Ashish and VDeevi,
Thanks for your notes - all of the CSF databases can be moved using the following process:
(a) Stop message flowing to all instances the connector, ideally this will be done be stopping the up-stream service(s).
(b) Stop the application pool in IIS, or use iisreset.
(c) Use SQL Server tools to attach/detach, or backup/restore, or even log-shipping to move the database to a new SQL Server machine.
(d) Verify, using SQL Server tools, that the database is intact and functioning.
(e) Change the connection string(s) in the connector configuration files.
(f) Restart the flow of messages to the connector by starting the up-stream service(s).
Many Thanks, Ashish and VDeevi!!
-Rob.
