moving 'Windows Embedded Data' folder location

[Vern]

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?

Thanks

Vern

 

[Vern]

Since no-one else seems to know the answer, I worked out one way, and am
reporting it here for others to follow if necessary:

The target directory is set on installing the tools. At least on the
'advanced installation' options, you are told where the target db is to
be installed, and you have the option there of changing this. I turned
off sharing for the 'repositories' directory inside the folder
Windows Embedded Data
then copied it to my target drive, then renamed it. I de-installed the
Windows embedded tools entirely. This left the installers behind, so I
then re-installed rev one of the databases using:
c:\program files\Windows Embedded\Installer\Disk1\Setup.exe
This created a new folder on the target drive called
Windows Embedded Data
At this point the repository directory was not shared, so I simply
renamed this folder
(or you could delete it),
then renamed my original copy back to
Windows Embedded Data.

Now I reinstalled the tools using
c:\program files\Windows Embedded\Installer\Disk2\Setup.exe
and advanced settings, selecting the target directory as mentioned
above. The product key for the install was in this directory too.
Then I updated the tools using
c:\program files\Windows Embedded\Installer\Disk3\Setup.exe

It wasn't necessary to install the SP2 for the databases because they
were already in the copied version of the original data I was trying to
preserve.

I am sure there is a quicker way to do this, but if you are stuck, as I
was, you CAN do it, and I have identified (to the best of my
recollection) the steps to do it.

Vern

 

[Andy Allred [MS]]

Yes you can relocate the location of the DB if you are have Windows admin
priveleges 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 and
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