This is kind of related to FPMI I guess, so I’ll post it here.
Let’s say I am doing some development on a project. I’ve added my database to the customer’s server (SQLServer 2005) and they started adding some data. In the meantime, I’ve made big changes to the the database on my dev machine, and need to restore it on the customer’s machine. What is the preferred method of retaining their data?
For instance, they have one table with a bunch of networking parameters. Befored I updated the database, I exported their table to a flat file via DTS, restored the database, and then imported the flat file back in. Is that the best way? Or would I better off writing a sql query that exported the data, and then another sql query that inserted the data back in? (using *.sql files)
Do you see what I mean? I’m just looking for a good long term approach for maintaining my data, and would like to automate it as much as possible.