Question

Upgrading SQL Express to Full SQL - version 9.1

Laserfiche Version 9

Updated December 7, 2023

asked on May 6, 2015

I feel like I should know this , but I just wanted to verify the steps necessary to upgrade a SQL Express database to full SQL.

Unregister the repository
Back up the database
Detach database from SQL Express instance
Attach it to full SQL server
Re-register the repository

The system started in 9.1 and is very new. No expansion databases or anything. Anything "special" need to be done such as running scripts from KB articles etc.?

1 0

Answer

SELECTED ANSWER

replied on May 6, 2015

You should know this But yes, the steps are correct if there are no expansion databases.

4 0

Replies

replied on September 22, 2015

Just to add some information found from other articles, incase someone finds their way here. You will need to run https://support.laserfiche.com/KB/1012313 if there are expansion databases!

1 0

replied on May 6, 2015

I thought there was an additional script that needed to be run, but that may have just been if there were expansion databases.

0 0

replied on December 5, 2023

Dear All,

Coming to this a little late. But what happens where the SQL Express DB has data in it. Do we export the DB from Sql Express and import into Ms SQL? I noticed nothing of this sort was mentioned.

Thank you

0 0

replied on December 5, 2023

Yes. Ege mentioned this in the initial post. The only exception to the instructions is if there are expansion databases. Then you would also need to follow the KB article that Kyle mentioned.

1 0

replied on December 7, 2023

Thanks Blake. Cleared that up!.

0 0

You are not allowed to follow up in this post.

Question

Question

Upgrading SQL Express to Full SQL - version 9.1

Answer

Replies

Sign in to reply to this post.