Well, I wouldn't write off the tool completely...it is a 1.0 version, and I can see potential in it. But I have found it to be painfully slow at times vs enterprise manager...and after 5 or so years with virtually the same interface in enterprise manager, it is hard to change.
On 3/6/06, Kenneth S. Redler <[EMAIL PROTECTED]> wrote: > Yeah, that's a good point. > > If you're looking at a database with tens of millions of rows, then I > suppose it would be untenable to do it any way other than as a backup. But > then again, you'd probably be looking at a dedicated db server in that case. > > > Is it really true that the tools with SQL Server 2005 are a step down? > That's bad news. I'm managing a large database in SQL Server 2000, and I've > been thinking of porting to PostgreSQL mainly due to the MS licensing costs. > Perhaps this is another nail in the coffin. > > On 3/6/06, Jim Wright <[EMAIL PROTECTED]> wrote: > > > > In hosted situations, you may not have the option of restoring a backup. > > > > On 3/6/06, Kenneth S. Redler <[EMAIL PROTECTED]> wrote: > > > I haven't used 2005, so you can take this for what it's worth (i.e., not > > > much), but why would you use DTS when you could just create a full > > backup, > > > then restore that whole wad on the new (2005) system? > > > > > > On 3/3/06, Jim Wright <[EMAIL PROTECTED]> wrote: > > > > > > > > Although...if you do use the red-gate tools...be careful of what it > > > > does to permissions...as my synch just removed the dbo permission from > > > > my database user...luckily a quick call to HMS had it fixed. > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2450 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=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
