ESF Database Migration Toolkit: From SQL to ORACLE without any fuss

Migrate your datase in 3 easy steps

As an IT professional working for a small to mid-sized organization you are not only in charge of the servers, desktops, firewalls, routers, switches and mobile devices… you’re the chief, cook and bottle washer. One of the tasks that threw me for a loop when I first started was working with databases, NOT MY REALM, way out of my comfort zone. In time though I got proficient enough to manage databases and I have been able to write and teach about SQL Server from the Network Administrators perspective. The one thing that still fills me with dread is the idea of migrating from one database to another. Now I am not talking about updating from SQL 2005 to 2008 or from Oracle 10g to 11g, these do a good job 99% of the time in taking care of themselves. I am talking about moving a database from Oracle to SQL or from SQL to Postgre SQL. In fact, I have had a few requests to help out and I have passed these projects up, simply too complex for a part-time, sort-of database person. However, there is a tool I recently discovered which can be a huge help in not only migrating databases; it can help migrate some older or perhaps outgrown databases, like FoxPro, dBase or Access. This tool can also help in migrating data sources (CSV, text or Excel) into a database. The tool is called the ESF Database Migration Toolkit . The ESF Database Migration Toolkit provides an easy to follow wizard that allows you to migrate databases from one format to another in three steps. Besides being simple the tool is also powerful. You can also rename tables, change datatype or filter data in the migration. The toolkit will migrate between different schemas and it migrates over Primary keys, indexes, LOB and Auto-ID’s. I ran it on a few test databases ( migrating SQL to MySQL) and I was surprised at the speed. The ESF Database Migration Toolkit comes in Standard and Professional (allows you to save/load migrations as a job, run as a scheduled Windows task, or use command line tools). The professional version is less than $300 for a single user and comes with one-year of upgrades and service. So if you find your need to migrate a database, don’t pick up that phone just yet. Try the ESF Database Migration Toolkit; of course it would be prudent to try it on a backup of your database first.

Recent Posts Slide Rocket: Create, Collaborate and share your slideshows in the cloud Remote Desktop Services: Some help to keep you from feeling 'Terminal'-ly lost ExRCA: Test your Exchange Server 2007 remote connectivity The iland Workforce Cloud: Go ahead keep your head and desktop in the cloud Small Business Server 2008: Turning 'OFF' IPv6 could be dangerous When Security Software goes BAD PageNest: Easily browse Internet sites offline PowerGUI unleash the power of PowerShell while using a familiar GUI management interface
Windows 7 Windows 7 Unveiled Will Windows 7 upgrade strategy keep XP users away…NO! Fun with Windows 7 Why Windows 7 will crush Linux Why XP users will switch to Windows 7 Why IT will adopt Windows 7
See my lists of great tools 12 killer freebie SharePoint add-ons Five great Windows open source tools 8 little-known technologies that instantly make Microsoft shops run smoother 9 wickedly useful Web sites for Windows administrators 12 cool cross-platform tools for Windows, Macs and Linux 20 great Windows open source projects you should get to know A Better Windows World Tools Library
Like this and want more? Check out the other tools I've written about in A Better Windows World. the Microsoft Subnet home page for more bloggers, news, humor, security alerts and more.

Plus, check out

Join the Network World communities on Facebook and LinkedIn to comment on topics that are top of mind.

Copyright © 2009 IDG Communications, Inc.

SD-WAN buyers guide: Key questions to ask vendors (and yourself)