Re: moving 'Windows Embedded Data' folder location
- From: "Andy Allred [MS]" <andyall@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 7 Mar 2008 13:54:23 -0800
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
--
Subscribe to the EW Team's blog for tips/tricks, How tos and announcements: http://blogs.msdn.com/embedded/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vern" <vern@xxxxxxxxxxxx> wrote in message news:u4UEEYlUIHA.5164@xxxxxxxxxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Automation error compiling with VB6
- Next by Date: Re: can't connect sql database
- Previous by thread: Re: XPE EWF RAM Memory Issues
- Next by thread: Re: can't connect sql database
- Index(es):
Relevant Pages
|
