Automating Database copy and rename procedure
Posted on 2007-03-23
I have created an application that is currently being used, but I still make updates to on a regular basis. I am using the FMS Start Up application, so I have a table in the application that is called tblVersion. All of the other tables are linked to a back end SQL Server database. When I make an update, I have to change the value in tblVersion, copy the database to the network location for office users, copy the db to another network location for my citrix users and finally rename the citrix version. I also create a back up copy on the network. I am trying to automate this process by creating a separate database that will connect to the target database, update the version number, copy the database to its new locations, and rename the database for the citrix users. I'd like to keep it in a separate mdb so I can use it as a log to keep track of the dates and reasons for the updates.