[AccessD] How to work Offline with SQL Server

When my clients use Access MDBs for the data store it is a trivial matter to set up mapped drives, 
and then link live / offline.

1) Create a "live data directory" and store the live data be in that.
2) Share that and map it as the X: drive on the workstations.
3) Link the FE to the BE on that mapped X: drive
4) Create a dev directory on my dev machine.
5) Share that.
6) Create a batch MapLive.Bat file that maps the Live directory as X: drive.
7) Create a batch MapLocal.Bat file that maps my local share as the X: drive.
8) Run MapLocal when debugging.  Any changes to data is written to the local copy of the BE on my 
hard drive.
9) Run MapLive when updating live data.  Any data changes written to the live database.

So, how do I achieve the same flexibility using SQL Server?  In this case the data resides in a 
database on a server.  In order to have the same kind of isolation from test to live I would have to 
maintain a mirror of the database somewhere.  It seems rather unwieldy.

Does anyone do this kind of thing using SQL Server as the data store?
-- 
John W. Colby
www.ColbyConsulting.com