|
|
Posted by Simon Hayes on 09/14/05 17:31
The latest production version of MSSQL is 2000; 2005 will be released
at the start of November. Which one of those you choose depends on how
compelling you find the features in 2005, and how cautious you are
about porting to a version 1 product. However, given that MSSQL 2000 is
already 5 years or so old, it would certainly worth be worth
considering 2005.
You should probably spend some time reviewing the product information
here, which includes migration guides and tools for porting from
Oracle:
http://www.microsoft.com/sql/default.mspx
As with any significant migration, tools will only take you to a
certain point - porting DDL and data may be relatively straightforward,
but procedural code is another matter, so you should be prepared to do
a certain amount of work by hand. And of course there are all the
issues of working with a completely new architecture, being able to
run/monitor/backup etc a new platform, the security model etc.
If your company has no previous experience of working with MSSQL, it
would probably be worth looking for someone who has, otherwise there's
a good chance that the migration will not be successful (or it may be
functional but perform unacceptably, have no robust security etc).
Personally, I would not be confident about porting an application to a
platform which I don't know, and your management needs to understand
the risks involved in that approach.
Simon
Navigation:
[Reply to this message]
|