Compartilhar via

Moving Your XPe Database File To A New Location

  • Artigo

In the newsgroup today I came across this post, here's the original question and my answer below that (but in this blog post I actually cleaned up some of my original typos :-) ).

Question from the NG:

I recently installed the Embedded Studio, and must not have been paying particular attention, so as a consequence the Windows Embedded Data folder ended up on the drive I use for downloads, and not C: drive, where I wanted it.

I have found out how to move the repositories, but the database remains in this folder.  How do I move it too?

Answer:

Yes you can relocate the location of the DB if you have Windows admin privileges on the machine and also are a SQL admin on that machine. I'm going to breeze through the steps here and assume you know how to use SQL, if not contact us at WECRT @ microsoft.com and reference this thread, we'll help you.

In the SQL Management Studio (or the old Enterprise Manager), locate the 'MantisSQL' DB and 'detach' it.

Now you can move the MDF and LDF files and their folder to a new location.

Back in the SQL Management tool, go to the 'Databases' node, right click and choose 'attach'.

From that new window, click 'add' and it'll allow you to browse to the MDF you moved. Go select it and choose 'ok'. Now you're in the 'attach databases' window again, click OK to accept this MDF/LDF it found.

Now you should see 'MantisSQL' in the list of databases. Go launch one of the XPe tools and ensure it can successfully attach to the DB as well. If so, you're good to go.

- Andy

Comments