If you're using SQL Server you can use a Data Transormation Services (DTS) package to coppy the data down to your local server. This can be done on a schedule in your local db using the SQL Server Agent to fire the event.
Otherwise, if you're uncomfortable with DTS, but have the IP address of the SQL Server where the live site is hosted, you can create a DSN on your development ColdFusion server for the live database, and use this to copy data from one the live db to the local db using ColdFusion and this task can be scheduled locally using a scheduled task in the coldfusion administrator. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > Hi list, > I have a project and am trying to determine the best way > to approach it. > Basically I have a database in the office which has tables > of adults and > children. These are related by children having the adultID > as a field in their > database. > I am trying to create an online database to allow online > registrations of > adults and their linked children. > The part I am not sure of is what is the best way to > export and import the > records that are created on the online database into the > local database. > Any suggestions would be appreciated. > Colin Wilson > ---------------------------------------------------------- > --------------- > This email server is running an evaluation copy of the > MailShield anti- > spam software. Please contact your email administrator if > you have any > questions about this message. MailShield product info: > www.mailshield.com > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
