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:2449 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
