You are viewing limited content. For full access, please sign in.

Question

Question

Migrating SQL to new server, version - Is "Change DBMS Connection" enough?

Laserfiche Version 9 Administration
Updated October 3, 2016
asked on October 3, 2016

Hello!

We need to move our Version 9 Laserfiche DBs from SQL Server 2008 to 2014.

I'm looking at the instructions for "Change DBMS Connection" (https://www.laserfiche.com/support/webhelp/Laserfiche/9.1/en-US/AdminGuide/LFAdmin.htm#Change_DBMS_Connection.htm) which sounds like the ticket - no need to restart the server.

But...  I'm not exactly clear about what this does?  From the doc, it mentions how the tool will create the DB for you, or you can select your pre-created blank db, so does this tool migrate all of the data for you?  

 

I was assuming we would need to unregister the old repository, then move the DB, then reregister the repository, but the option above seems nicer.

 

Thoughts?

0 0

Replies

replied on October 3, 2016

Changing the DBMS connection just points the LF Server to a different SQL server and database. It does not migrate any data.

You would have to detach the SQL database from SQL Server and move it, then attach it to the new server. Then you'd change the DBMS connection.

It's faster than unregistering and re-registering for the case where nothing else changes but the SQL server. You still want all users out of the repository while you're moving the SQL database.

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...