View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 02:40 PM
HP
 
Posts: n/a
Default Accessing one db by two sql server installations (eg. native vs vmware)

Hi there

As many people nowadays, I have 2 XP installations on my laptop - one
running natively and one in vmware box running on ubuntu (situation
even more common with osx on intelmacs).

Since I would like to be able to work on same development projects in
both these environments, depending on the situation, I was wondering
how should I cope with DBs synchronization.

The simplest solution would be deploy the database in native windows
sql server installation, and attach the _same_ database files when
running from vmware (via sharing their folder on mounted ntfs
partition).

Would it be possible at all without any data corruption assuming I
would run the same server versions (same SPs applied etc.)?

thanks
HP

Reply With Quote