Rusty Hammond
rusty.hammond at cpiqpc.com
Sat Jan 9 10:51:24 CST 2010
John, Another way to do it if they don't mind you having their data, is to backup their database to a file, then restore it onto your server for developing against. Then you have actual data to work with. HTH -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, January 08, 2010 7:43 PM To: Access Developers discussion and problem solving Subject: Re: [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? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. **********************************************************************