MySQL Connector/Net 6.6.3, a new version of the all-managed .NET driver for MySQL has been released. This is the second of two beta releases intended to introduce users to the new features in the release.
We recently released a new migration tool for Microsoft SQL Server to MySQL, along with additional tools and features improving the MySQL user experience on Windows (http://www.mysql.com/why-mysql/windows/).
In the latest episode of our "Meet The MySQL Experts" podcast, Alfredo Kojima, Senior Software Development Manager, talks to us about the new migration tool.
Enjoy the podcast!
To learn more about SQL Server to MySQL migrations, MySQL on Windows and numerous other MySQL topics, register for[Read more...]
MySQL Workbench 5.2.41 introduces a new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. In this initial version, migrations from Microsoft SQL Server are supported, but it should also be possible to migrate from most ODBC capable RDBMS as well, using its generic RDBMS support. Additionally, you can use it to perform MySQL to MySQL database copies, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL.
So let’s get our hands dirty and run through the Migration Wizard in order to migrate a Microsoft SQL Server database to MySQL. In the rest of this post I assume that you have:
I learned how to use a computer on DOS and Windows. My first programming projects were written in QBASIC and my first Web applications were written in VB using ASP on Windows 2000. The first job where I made decent money was developing a SQL Server-based application. I bought my first car, an engagement ring, and a honeymoon with money from making software on Windows. Needless to say, I found a lot of intellectual and financial fulfillment from Windows over the years.
That first real job also allowed me flexibility in what technology I could employ, and I helped implement a features using Redis on top of Ubuntu. This was a fun time, because my company basically paid me to study a new technology and to gain experience using it. On my own, I began to use Linux and to embrace open-source ideas, one of which is that the consumer[Read more...]
My colleague who is a Windows guru taught me how to do very basic things with the Windows profiler. While this stuff is primitive, the sad truth is that many people don’t know even this little about Windows, me including. I’ll keep the hints here, and hopefully will learn more with time.
Start => All Programs => MS Visual Studio 2010 => Visual Studio Tools => Visual Studio x64 Win64 command prompt
set _NT_SYMBOL_PATH=... && devenv.exe
There was a point a few years ago where Sun could have had the next generation UNIX filesystem. It was in Solaris (and people were excited), there was a port to MacOS X (that was quite exciting for people) and there was a couple of ways to run it on linux (and people were excited). So… instead of the fractured landscape of ext3, HFS+ and (the various variations of) UFS we could have had one file system that was common between all of the commonly used UNIX-like variants. Think of being able to use a file system on a removable drive that isn’t FAT and being able to take it from machine to machine (well… Windows would be a problem, but it always is).
There was some really great work done in OpenSolaris with integration between the[Read more...]
Recent news that Microsoft and Barnes & Noble agreed to partner on the Nook e-reader line rather than keep fighting over intellectual property suggests the prospect of more settlement and fewer IP suits in the industry. However, the deal further obscures the blurry IP and patent landscape currently impacting both enterprise IT and consumer technology.
It is good to see settlement — something I’ve been calling for, while also warning against patent and IP aggression. However, this settlment comes from the one conflict in this ongoing war that was actually shedding some light on the matter, rather than further complicating it.
See the full article at TechNewsWorld.
Now that we have finished 6.5 it's time to really start gearing up for 6.6. We have many great feature ideas but we want to hear from you. To help with that, we're running a poll on the website where you can vote on the features you would like to see in the next version of the best MySQL ADO.Net Connector on the planet. You can find the poll at http://dev.mysql.com and scrolling near the bottom of the page.
Thanks for your time and please go vote.
We recently released Connector/Net 6.5 as GA. Our policy is that we actively support the last 2 GA versions of the Connector so we are dropping support for Connector/Net 6.3. Any users who are actively using 6.3 are encouraged to upgrade to the latest version. You can find the formal announcement at http://mysql.com/support/eol-notice.html
A screencast demonstrating the MariaDB Windows installer.
(I recommend watching it in full screen 720p, so you can see the details.)
A big thanks to Vladislav Vaintroub, MariaDB’s Windows guru, and to Rasmus Johansson for help with the screencast.
If you are a Windows user concerned about the new licensing and pricing of SQL Server 2012, we encourage you to try the MySQL TCO Calculator! (http://www.mysql.com/tcosavings/)
You’ll discover how you can reduce your database TCO by up to 96% with MySQL Enterprise Edition vs SQL Server 2012 Enterprise Edition*.
While MySQL is famously known as the "M" of the popular LAMP stack, Microsoft Windows consistently ranks as the #1 development platform for MySQL users in our surveys. Indeed, MySQL on Windows enables you to:
Some time ago I wrote a post introducing two members of my team, Fernando and Gabriella. I was focused at the time on introducing relatively new members to the team and, in my error, I failed to introduce one member who has been with me for quite some time. We have also since added 3 more individuals to our growing team. This team is called the Windows Experience Group and we are doing some really exciting work. You've already met Fernando and Gabriella. Here is the rest of the team.
Iggy Galarza leads our MySQL Installer team.
Iggy has been with MySQL since 2006 and has been an integral part in many initiatives ranging from the MySQL installer to solving server[Read more...]
Note: I’ve decided not to use Veewee due to silly compatibility issues for now.
Quoting from Vagrant’s web site:
Vagrant is a tool for building and distributing virtualized development environments. By providing automated creation and provisioning of virtual machines using Oracle’s VirtualBox, Vagrant provides the tools to create and configure lightweight, reproducible, and portable virtual environments.
1. According to
Previously, I’ve called out years for non-desktop Linux in 2008, Linux in both the low and high-ends of the market in 2009, ‘hidden’ Linux in 2010 and last year, cloud computing in 2011. For 2012, I see continued growth, prevalence, innovation and impact from Linux, thus leading to a 2012 that is dominated by Linux.
I expect to see nothing but continued strength for Linux and[Read more...]
As you probably know, there were some problems using our connector in medium-trust level scenarios. Most hosting services provide MySQL access. Most of these hosting providers run their .NET web apps using medium trust. Prior to 6.5, our connector required the hosting provider to either run the application in full trust or to enable broad privileges like SocketPermission globally. Many hosting providers are unwilling to do that. So fully enabling our provider to run in a partial trust scenario was a strongly requested feature. The request was a very simple task: enable Connector/Net to work correctly in a medium-trust level environment when the library is installed in the GAC.
The implementation consisted of including the necessary security imperative asserts so the CLR allows our code to perform the operations where it needs[Read more...]
We have a new feature as part of the 6.5 release. There is a new class that you can use to restrict access to specific connection strings that you want to use in all the connections in applications that use MySQL databases.
The following example shows how you can use the MySQLClientPermission class to restrict access to a specific server name and a database, while allowing any value for the User Id and Password within the connection string:
MySqlClientPermission permission = new MySqlClientPermission(PermissionState.None);
permission.Add("server=localhost;database=test;", " user id=; password=;",
MySqlConnection myconn = new MySqlConnection();