Transferring a component database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am taking over an XPembedded project from another developer at our company. He has a component database built up wtih drivers and programs for some of our applications. I have attempted to move that database onto a different machine for my use unsuccessfully. Any help would be appreciated.
 
jtwitmer,

And how did you do the attempt?

You may want to use SQL Server Enterprise Manager to deattach from the
Mantis Db. Then move it along with the Repository directories to another
machine and attach it there.

KM
I am taking over an XPembedded project from another developer at our
Click to expand...
company. He has a component database built up wtih drivers and programs for
some of our applications. I have attempted to move that database onto a
different machine for my use unsuccessfully. Any help would be appreciated.
 
jtwitmer,

I haven't tried the SQL Import/Exprot data wizard but I doubt it is going to
work in your case.

What I referred to is simply copying the db files manually to another
location (another machine, actually). But to copy the files, you first need
to force SQL server to unlock them and not to use while copying. Click on
the db node in Enterprise Manager (Mantis Db), and find Dettach item.
Search this NG archive for more detail steps. I remember mentioning the
steps here.

KM
I'm not entirely sure what you mean. I tried doing the transfer using the
Click to expand...
SQL Import/Export data program unsuccessfully. Is there another process
you're referring to?
 
Thanks...that worked just fine.


KM said:
jtwitmer,

I haven't tried the SQL Import/Exprot data wizard but I doubt it is going to
work in your case.

What I referred to is simply copying the db files manually to another
location (another machine, actually). But to copy the files, you first need
to force SQL server to unlock them and not to use while copying. Click on
the db node in Enterprise Manager (Mantis Db), and find Dettach item.
Search this NG archive for more detail steps. I remember mentioning the
steps here.

KM

SQL Import/Export data program unsuccessfully. Is there another process
you're referring to?
Click to expand...
 
Note that when you transfer the DB you must go to the Embedded tool Database
Manager, click on the Repository tab and update the repository paths.

If you're manually copying the rep folders and share over, then UNCHECK the
box for "copy files" when you try to update the machine name in the rep path
line.

You will also need to click on the Rep Root button and update the repository
root, delete the old machine name and change it to the new rep root
location.

The reason for this is that this repository location information is stored
in the MantisSQLDB file that you transferred over from the other machine.

Andy
 
Back
Top