MYSQL UUID WINDOWS

Most of the tables in the original database have an ID column which has a default value of newid(). The style I have chosen is the slowest and takes up the most space but is also, arguably, the most human readable and is the best match for what is currently happening in the application.įor my sins I then had to address what to do about inserts. Alternatively you can store it as a char(32) without dashes, as a 16-byte binary or a couple of other types. This stores the complete UUID as a text string with dashes. There are several ways of storing a UUID in MySQL and I’ve opted for what I feel is the best match with MS SQL which is a char(36) column. MySQL has a UUID function which will return an identifier but there no column type of UniqueIdentifier as there is with MS SQL. The first issue i faced was what to do about the GUID keys in the MS SQL databaes. I’m concerned that if I jump into this project I’ll end up introducing dozens of new bugs which is ironic because one of the reasons I want to get it working against MySQL is so that I can easily run unit and integration tests on the CI server. The real problem though is the code, it’s a bit of a mess. I’ve toyed with the idea of doing this before but I’ve always shied away from it, the application makes heavy use of stored procedures and the SQL makes moderate use of MS SQL syntax. The alternative therefore seems to be to make the application run on another database and in my case that would be MySQL. It’s probably worth pointing out that I wouldn’t be making sufficient use of the database to justify it living in it’s own box, in production I would almost always have the database running on a separate machine.

MYSQL UUID WINDOWS

I could tackle this problem by setting up Windows machine and running a copy of MS SQL on that but we already have more servers than we probably should have and I don’t want to have to dedicate a whole machine to this one task. The problem comes when I want to deploy and test it on one of the company servers because they all run Linux and there is no way to run MS SQL under Linux (see note 1). For the most part this hasn’t proven to be that much of a problem as everyone who uses the application also runs MS SQL. One of the applications I maintain currently only runs against Microsoft SQL Server.

Mysql uuid