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

Question

Question

SQL instance change from Standard to Express?

Laserfiche
Updated December 31, 2015
asked on December 31, 2015

My client wanted to know if it's possible for a user who had a test system that was full SQL and wanted to use the same database but with an express instance?

0 0

Answer

SELECTED ANSWER
replied on December 31, 2015

Hi Ricardo,

Per this thread, there is no directly supported method of migrating a full-SQL system to an Express system; furthermore, because of differences in schema, attempting to attach a full SQL database to SQL Express will cause errors. If the metadata information from the test system does not need to be migrated to the Express "production" system, then you should be able to get by with exporting the volumes from the full SQL machine, then attaching to a new repository which has the SQL Express as its DBMS.

Hope this helps!

1 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...