asp_databases thread: sql question for the experts...
what's the best method to move data from development server to production?
now that seems a simple question, but here's what needs to move:
table : packages
fields : id, name, etc...
table : packageFAQ
fields : packageID, q, a
table : packagePrivileges
fields : packageID, menuID
the records in development that need to be moved are in this sql select:
SELECT ID FROM Package WHERE StatusID=2 AND CategoryID=10 AND ID NOT IN
(635, 642)
(this is sql server 7)
shane