We are considering upgrading SQL 2000 to SQL 2005. I just love the idea of getting newer technology, But i'm hesitant to upgrade MS stuff, cause of bugs and licensing stuff... So here's what i'm wondering:
1. If we move to 2005, will we lose any databases/querys/dts packages/etc ?? or is it a seamless upgrade from 2000?
2. Would we have to uninstall 2000 and then install 2005, or is it an in-place-upgrade type of thing?
3. Does 2005 have a forced on-line registration that you have to go through (sort of like how XP has to be "activated")?
4. If we use SQL 2005, and end up using more connections that we purchased, will SQL fail or give an error message? SQL 2000 does not give this problem.