Originally posted by: trans53
It is possible to move per-cpu licenses we currently use for SQL Server 2000 into SQL Server 2005 since for the old server we only need per seat licenses?
Also, are there any issues when one server is SQL Server 2000 and another is 2005 and they are connected to each other?
We will also need to do some data migration from one into another.
1: Not without a "Technology Upgrade Gaurantee" or somesuch other upgrade clause. We did this when going from 7.0 to 2000 and managed to save significant license costs. I do not know if MS is still offering this type of license upgrade. Also, since you're still running the old 2000 server, those licenses technically aren't really available to be transferred...
2: Not if they're physically seperate servers. You only need to be considerate of the differences between the platforms (syntax, options etc).
3: DTS, custom ETL via T-SQL, backup/restore, replication...there's eighty-jillion-ways to migrate data...