Transfering Data (A Best Pratices Question)
To be objective I will not tell how I do it, I need the input from someone else to insure that what I am doing is 'correct'. It is even possible that there is a command that I have over looked.
Scenario: By the philosophy of 'best practice' no field shall be used for two purposes; the same must hold true for a singular database (or table within a database). For this discussion I have EITHER two tables in the same database (with no relationship set) or two separate databases. The two tables or database have nearly the same field names but have two different purposes (example: a wish list, and a have list).
What would the best practice procedure for moving one record or a block of records from Point A to Point B?
Peter Kelley, St. Paul, MN USA
Sorry, but what you describe lacks sufficient detail to be able to answer. Often the "best practice" will be not to move the data at all. But that is only the case some of the time.
To work from your example, your "wish list" and "have list" might be records in the same table. "moving" the data might simply require changing a single field's value from "Wish for" to "Have".