[AccessD] How to work Offline with SQL Server

I guess so.

The client was sold a conversion to SQL Server.  When things no longer worked I was called up to 
straighten out the mess.  This is really the first client that now actually uses a SQL Server BE, so 
I don't have any experience in how to maintain a development data store.

John W. Colby
www.ColbyConsulting.com


Rusty Hammond wrote:
> Ahh.  To keep them in sync structure wise, you can script the database,
> then run the script on the test db to create all of the tables, views,
> stored procs, etc..  This basically requires blasting away the current
> version and creating a new one.
> 
> If you want to keep the database intact and just make changes to make it
> match, you have to write your own sql scripts that will modify the
> objects in your database.
> 
> Is that what you needed?