Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: sql question for the experts...


Message #1 by "Blake, Shane" <Shane.Blake@p...> on Tue, 26 Jun 2001 11:01:23 -0400
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




  Return to Index