Thanks for your suggestion Jeffrey. I have a number of web sites in a shared hosting environment. The system admin is supposed to do a database backup every night, but I don't feel safe relying on that. I want to see my own backups done. So I need to make copies of my online production data regularly.
Also I have a number of sites where I do the data updates locally, then publish the site every couple of days. In one case I have a deadline of midday Friday every week. In the old SQLServer2000 days, I just had a scheduled DTS task in Enterprise Manager to handle all that stuff automatically from my own network server. However I haven't been able to see how it's possible in SQL2005 since they don't support DTS any more. (yes, you can convert old DTS packages, but you can't make new ones, that I've seen. So as soon as you make a change to your database the old DTS packages wont work). You can't rely on anything that's in SQL2000 being in SQL2005, except that the data is compatible between the two. Cheers Mike Kear Windsor, NSW, Australia Macromedia Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month -----Original Message----- From: Jeffry Houser [mailto:[EMAIL PROTECTED] Sent: Saturday, 8 April 2006 2:18 PM To: SQL Subject: Re: Has anyone found out how to replicate in SQLServer2005 yet? Are you talking about keeping records in sync or the database design? To update records in a development or testing environment, I usually just restore a backup of the live database over the dev or test database. This is done rarely, maybe once a month, maybe once a year. I rarely do development tasks that need the most up to date data. as long as there is an acceptable sampling, I'm set. All that said; I use ApexSQL Diff: http://www.apexsql.com/sql_tools_diff.asp It works for both the structure and data. I have not tested in 2005 yet. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2464 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
