Upgrading server

Last Post 09 Jan 2007 01:29 PM by Haywood. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
trans53
New Member
New Member

--
09 Jan 2007 01:24 PM
Guys, I have this question:

Currently we have a SQL Server 2000 installed on Windows 2000 Advanced Server.
We are planning to split the database installed on this server into two databases and move one database(biggest)
into a new server.
For now we don't have any plans to upgrade the existing server with SQL Server 2005.
Also, currently this server has per-cpu licenses.


What we are planning to do:

We are planning to buy a new server with Windows 2003 installed and install SQL Server 2005.
At this point I am not sure if we still can buy SQL Server 2000 or not. (Doesn’t make any sense anyway)

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.

Thanks
Haywood
New Member
New Member

--
09 Jan 2007 01:29 PM
quote:

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...

trans53
New Member
New Member

--
09 Jan 2007 02:14 PM
Thank you for reply, also do you know if one can still buy sql server 2000 or 2005 is a must have now?
Haywood
New Member
New Member

--
09 Jan 2007 03:03 PM
IIRC, you'll be able to purchase SQL2000 until sometime in 2008.
You are not authorized to post a reply.

Acceptable Use Policy