June 22, 2007 at 11:52 am
We're going to begin converting an old application which uses MS Access to use SQL Server 2005 Express. One of the biggest problems is the database structures. On the back-end server, we have 3 SQL Server 2005 databases that hold all of the data for this legacy application. However, the local storage is going to only have 1 SQL Server 2005 Express database; thus we combine the various tables from the 3 different databases into 1 database. (That is what we currently do with the MS Access database.) (The local MS Access database does not have all of the tables that are in the 3 SQL Server databases - just enough to be able to run the application.)
Anyway, the issue we face is how do we replicate changes to any of the tables, stored procedures, etc. that occur in any of the 3 SQL Server databases down to the soon-to-be local SQL Express database? I have created a table in the back-end servers where I was going to put in the relevant SQL script to do database changes (ALTER TABLE, ALTER PROCEDURE, etc). However, my colleagues have suggested that perhaps we could put a master copy of the SQL Server 2005 Express database onto one of our server, and then the database schema could some how be replicated from the master to the user's local SQL Server 2005 Express databases.
That sounds like a great idea. Can we do it that way?
Kindest Regards, Rod Connect with me on LinkedIn.
July 6, 2007 at 5:50 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply