Thanks!
"Brian Roepke (Autodesk, Inc.)" wrote in
message news:5147258@discussion.autodesk.com...
This should be pretty easy - start with some background to answer your
question:
The SQL has what are called Instances - think of these like opening two
sessions of inventor - they run independently from each other. SQL does
this in order to isolate the two processes for safety reasons.
The first folder MSSQL$INVENTORCONTENT contains the unique software to
run that Instance installed for content center while the second folder
MSSQL$AUTODESKVAULT contains all the stuff for vault. In these folders
there is a sub-folder called "DATA" which you've probably found - this
holds the databases from each instance. You probably recognize some of
them... (by name)
Now... the goods... how to move them.
This is actually a simple process.
First - With Inventor 10, start the special Content Center Library
Manager application and use the "Detach" command for each of the
libraries. Repeat this for all your libraries. You can do this for
custom or default. This depends on whether the server has a copy of the
default ones or not yet.
Second - Go to the "Data" folder under MSSQL$INVENTORCONTENT and look
for pairs of files that are named after each of the libraries you
detached. You don't need to grab all the databases in here, just the
ones you need. Remember there are two files for each, a database and a
log file. (MDF and LDF i think...)
Third - *Copy* these over to the server and drop them in the servers
"data" directory under MSSQL$AUTODESKVAULT.
Fourth - Open the Content Center Library Manager application on the
server and use the "attach" command. Repeat for each library.
Fifth - Back on your client machine perform the previous step attaching
the libraries back that you need local. (local libraries should only be
needed if you are using a laptop on the road away from the vault
server.) Just remember not to make any edits to this local server if
you choose to keep the custom libraries here.
--
Thanks,
Brian Roepke
Product Manager, MSD
Data Management