Home > database >  Solution: SQL server GUID import to mySQL have braces {}
Solution: SQL server GUID import to mySQL have braces {}

Time:10-21

SQL server many table fields with the GUID, convenient for synchronization and replication
Now I find I use NaviCat through ODBC import data to MySQL, the import of the GUID is with braces, such as {fcc55 A02C - 442 - c - 009 - A06F - 901 e0ca09b92}, actually I want fcc55 - A02C - 442 - c - 009 e0ca09b92 A06F - 901

Really don't want to write programs to import and export, dozens of gigabytes of data and so on the GUID field
Do you have any good method? Or good tools?
thank you

CodePudding user response:

Try a different tool,

Or directly using SQL server SSMS client, the export data to mysql,

CodePudding user response:

reference 1st floor yupeigu response:
try changing tools,

Or directly using SQL server SSMS client, the export data to mysql,


The answer is drunk drunk again, don't understand, don't blather

CodePudding user response:

The SQL server database UNIQUEIDENTIFIER data types into NVARCHAR to import
  • Related