New answers tagged

3

First rename the schemas in the current databases to have the names you want to end up with: alter schema public rename to schema_a; And the same for other databases. Whether you need to change your apps, SQL functions, etc. depends on what kind of coding standards you used in the first place. This can probably be done with the system online, if your ...


1

When dumping, use the option to not write the CREATE DATABASE statement. When reloading, specify a new, empty, database on the mysql command. That will put the imported data in a different database. You can then compare them, or do whatever. However, if you plan to move them into the old db name, you would have to do DROP TABLE + RENAME TABLE one table ...


1

So, you want to import the new data without overwriting and no duplicate keys, right? I'm no expert, but as I see it, you can either: Remove the current data and import the whole old DB, Use --ignore or --replace on mysqlimport - either won't duplicate rows (they'll either --replace existing rows or --ignore duplicates), mysqldump without creating the ...


1

Seems you've found a bug in migration wizard, I follow your description and I was able to repeat issue on my machine. Can you please fill bug report at bugs.mysql.com? Appreciate. We'll do our best to fix that isse. As workaround you can try this way - use Data Export to export only structure of your database. Run exported stricpt on target server. Then run ...


12

Should I be concerned? Well, there are a couple of things here that are a little concerning. First: while it is true that a UNIQUEIDENTIFIER (i.e. Guid) is a 16-byte binary value, it is also true that: All data can be stored in binary form (e.g. INT could be stored in BINARY(4), DATETIME can be stored in BINARY(8), etc), hence #2 ↴ There is probably ...


4

You can always be concerned. ;) The system may have been migrated from some other system that doesn't support uniqueidentifier. Are there other compromises you don't know about? The designer may not have known about the uniqueidentifier type. What other things didn't they know about? Technically though - it shouldn't be a major concern.



Top 50 recent answers are included