Who doesn't support DTS? the host ot SQL Server 2005? I can assure you the latter does indeed but you cannot created or edit a DTS created on a SQL 2K server from 2005 Management Studio.
Are both your host and yourself / dev on 2005? N Quoting Mike Kear <[EMAIL PROTECTED]>: > 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:2465 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
