fli - Wednesday, April 17, 2013 12:39 PM:
Hi,
We are developing a setup for our Aras development :-)
Has anybody experience with using a db located elsewhere that in the normal sql folder?
I'am trying to replace following line in the InnovatorServerConfig file
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="(local)SQLEXPRESSR2" uid="innovator" pwd="xxx"/>
The best quess yet is the following, which is not working
<DB-Connection id="InnovatorSolutions" AttachDbFilename="C:DevCPH.EA.ArasTrunkExternalArasDBInnovatorSolutions.mdf" server="(local)SQLEXPRESSR2" uid="innovator" pwd="xxx"/>
The purpose is that this is suppose to help when using a application management lifecycle tool, and will allow for the db to be checked in/out of the AML system.
Regards Christoffer
gks by TSI - Thursday, April 18, 2013 2:32 AM:
> Has anybody experience with using a db located elsewhere that in the normal sql folder?
This part is no problem. most of the databases i run are located somewhere else.
I don't know if this works in sql-server express, but i change the path of the database when creating a new Database inside sql managment studio.
but
> The purpose is that this is suppose to help when using a application management lifecycle tool, and will allow for the db to be checked in/out of the AML system.
wouldn't work, as the database is in use by the sql-server so no chance to upload/download the database (it would be corrupt or file would be in exclusive use
to build up such a szenario i'd recommend to create a 2 scripts:
one backups the database to your directory and makes a checkin, the other makes a checkout followed by a restore.
the script should be able to handle a fail of backup and restore, which can happen.
btw i didn't know about "AttachDbFilename" is this attribute described anywhere?
