Feeds

Moving to SQL Server

  • alert
  • submit to reddit

The essential guide to IT transformation

Dmitry Balin of Microsoft has been telling me about Microsoft's new Oracle migration toolset. Oh, BTW, I think it only works one way - from Oracle to SQL Server. Who'd have thought it?

Nevertheless, it sounds pretty good. And, I'm promised some real migration case studies (ie, not from SQL Server 2000 to 2005) Any Day Now.

But an interesting aspect of this is that you might never migrate, even if SQL Server is great and the toolset is all Dmitry says it is.

Supposing that SQL Server is far more cost effective than Oracle and equally powerful (and the jury is still out on this), the real costs of migration may come from recreating the semantics behind your database, and regression testing your apps after conversion.

So, a major use of this toolset could still be in estimating the cost of migration and in enabling pilot studies. But, still, a fast tool is welcome - if you're going to get bad news, best get it fast - and get over it.

Bercause migration isn't the only path. Why not wrap databases as cross-platform services - unless or until you can actually cash in on a migration by abandonong an entire platform? Remember, you can't generally claim the savings from moving off an old box until you actually junk it...

Secure remote control for conventional and virtual desktops

More from The Register

next story
Munich considers dumping Linux for ... GULP ... Windows!
Give a penguinista a hug, the Outlook's not good for open source's poster child
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Intel's Raspberry Pi rival Galileo can now run Windows
Behold the Internet of Things. Wintel Things
Microsoft cries UNINSTALL in the wake of Blue Screens of Death™
Cache crash causes contained choloric calamity
Eat up Martha! Microsoft slings handwriting recog into OneNote on Android
Freehand input on non-Windows kit for the first time
Time to move away from Windows 7 ... whoa, whoa, who said anything about Windows 8?
Start migrating now to avoid another XPocalypse – Gartner
You'll find Yoda at the back of every IT conference
The piss always taking is he. Bastard the.
prev story

Whitepapers

Endpoint data privacy in the cloud is easier than you think
Innovations in encryption and storage resolve issues of data privacy and key requirements for companies to look for in a solution.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Solving today's distributed Big Data backup challenges
Enable IT efficiency and allow a firm to access and reuse corporate information for competitive advantage, ultimately changing business outcomes.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.