1 Topic by atheta01

  • atheta01
  • Veteran
  • Offline
  • From: YNU Coleoptera recorder
  • Registered: 30-10-2009
  • Posts: 325

Topic: Separate databases

Can I run two separate databases in the same R6 installation without having to switch between separate .bak files? I would like to keep the two datasets entirely separate.

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

atheta01's Website

2 Reply by AndyFoy

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Re: Separate databases

Yes you can, but you will have to edit the registry to switch between the two databases (which is much quicker than reloading from a backup or detaching/attaching a different set of files).

I use a .reg file to switch between two different SQL Servers but you can also switch database names.  The .reg file I use contains (between the dotted lines) ...

----------------------
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Dorset Software\Recorder 6]
"Database Name"="NBNData"
"Server Name"="NOVO\\SQLEXPRESS2012"
----------------------

You might need to amend the HKEY path to match your installation path.

Andy

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk