(Jan Stafford) It’s no small feat to manually migrate an enterprise from Microsoft SQL Server to MySQL, but it can be done. In part 3 of our series on migrating to MySQL, Mike Sheffey, CEO of migration tools vendor Versora, gives step-by-step instructions for two manual tasks: moving the data struct
Tag: Open Source
Use Case: An Open Source Alterative to HP OpenView
(Robert McMillan) A growing number of Open Source sysadmins and developers are working on web services projects, and are finding themselves mixing their Open Source and commercial software to deliver innovative solutions.
Migration prep, part 2: Comparing MySQL and MS SQL Server
(Jan Stafford) Microsoft SQL Server does have features that can’t be found in MySQL 4, according to Mike Sheffey, CEO of migration tools vendor Versora. But that situation is probably temporary. In part two of our series on migrating to MySQL, Sheffey discusses what users need to know about thos
MySQL 5 to open once-closed doors
(Jan Stafford) MySQL AB CEO Marten Mickos won’t reveal the release date of MySQL 5.0, but he does promise that it has all the goodies requested by database developers and corporate users. There are three enterprise-level flagship features in MySQL 5.0: stored procedures, triggers and views. Get
Migration prep, part 1: When to switch from MS SQL to MySQL
(Jan Stafford) Not every organization should dump Microsoft SQL Server, according to Mike Sheffey, CEO of Versora, a migration tools vendor. Sometimes the vendor lock-in is too strong to break without overhauling everything in the enterprise. But when there is a window of opportunity, Sheffey says c
MySQL 5.0 New Features: Stored Procedures
(Peter Gulutzan) This 67 page guide is for long-time MySQL users who want to know “what’s new” in version 5. The short answer is “stored procedures, triggers, views, information_schema”. The long answer is the MySQL 5.0 New Features series, and this book is the first in the series.
Entrepreneurs turn to open source DBMS vendors
(Rob Westervelt) Like other entrepreneurs, Roger Holden knows that starting a business is risky. Part of that risk involves assembling the right IT infrastructure on a limited budget. (R)
Choosing the Right MySQL Version and Reporting Bugs
(Arjen Lentz) People often ask me about which MySQL version they should use, whether they should consider upgrading, what to do when they find a bug, and so on. Though these things are covered in the MySQL Reference Manual and other places, this article aims to cover all the essentials in the one pl
Modifying Slony Clusters
(A. Elein Mustain) Replication clusters have much forethought applied to their creation. However, in the course of systems development, some changes are always necessary sooner or later. This article walks through the steps required to: –Add a node to the cluster. –Switch data providers of a
Implementing PEAR’s DB package
(Phillip Perkins) PHP provides the adept developer with the tools to create some powerful Web solutions. Moreover, with the ability to add additional functionality through extensions, it makes creating solutions easy. PEAR, the PHP Extension and Application Repository (http://pear.php.net/) is a fra