Accessing one db by two sql server instances (eg. native vs vmware)

Hi there
As many people do 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 between two sql server
instances running under those two environments.
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). So the DB files would attached to two servers, but of
course they would never be accessed at the same time.
Would it be possible at all without any data corruption assuming I
would run the same server versions (same SPs applied etc. - for the
time being it's 2kSP4)?
thanks
HP> So the DB files would attached to two servers, but of
> course they would never be accessed at the same time.
This should work fine. Regular backups won't hurt either.
Note that the Best Practice in development is to keep database DDL scripts
under source control rather than only in a physical database.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"HP" <ha5en1@.gmail.com> wrote in message
news:1187778620.953857.97210@.x40g2000prg.googlegroups.com...
> Hi there
> As many people do 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 between two sql server
> instances running under those two environments.
> 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). So the DB files would attached to two servers, but of
> course they would never be accessed at the same time.
> Would it be possible at all without any data corruption assuming I
> would run the same server versions (same SPs applied etc. - for the
> time being it's 2kSP4)?
> thanks
> HP
>