Dealing with multiple development locations

[Richard Carpenter]

My wife and I share a laptop. When she is using it, I must do my
development on my PC. I have SQL Server 2005 Express installed on
both, but the instances are named differently. Therefore, I need to be
able to redirect my projects to a different server each time I switch
between machines.

What is the best method of accomplishing this? I am using both C# and
VB.

By the same token, what is the best method of copying my development
database between the two SQL Servers? Backing it up on one and then
restoring it on the other would be my best guess, but I had trouble
doing just that recently after a reinstall of SQL Server on one
machine. It would not restore the database if it didn't already exist,
and I didn't know the particulars to re-created it from scratch
(initial file sizes, growth rates, etc.).

Thanks!

Rich

 

[RobinS]

If you name them the same thing, you could put them on a memory key
(depending on how big the database is) and switch it back and forth between
the computers, then you'd always have the most current version of the
database. I am not certain about SQLExpress, but with regular SQLServer,
you get to specify the location of the files, so you can attach any
database anywhere. I would think SQLExpress would be the same way.

Robin S.

 

[Richard Carpenter]

If you name them the same thing, you could put them on a memory key
(depending on how big the database is) and switch it back and forth between
the computers, then you'd always have the most current version of the
database. I am not certain about SQLExpress, but with regular SQLServer,
you get to specify the location of the files, so you can attach any
database anywhere. I would think SQLExpress would be the same way.

Robin S.







- Show quoted text -

I have tried that in the past, and accessing the data on the flash
drive was really slow. Any other ideas?

Rich

 

[RobinS]

Buy a faster flash drive? Or put it on an external hard drive (I have a
mini one that holds 80GB) and move *that* from computer to computer?

Robin S.
=--------------------------------

 

[Richard Carpenter]

Buy a faster flash drive? Or put it on an external hard drive (I have a
mini one that holds 80GB) and move *that* from computer to computer?

Robin S.







- Show quoted text -

Well, the flash drive I have qualifies for use as a "Ready Boost"
drive in Windows Vista, so it's pretty fast, as far as flash drives
go.

Thanks for the tip though. That may be my best option.

Rich