New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ExportSqlCE40: Export SqlCe uniqueidentifier column data to SQLite as binary #982
Comments
"BinaryGUID" is not a valid SQL Server Compact connection string keyword, correct. There a many opinions about storage of Guids with SQLite - dotnet/efcore#15078
Anything is possible! But it would have to be an opt-in flag to avoid breaking changes - interested in doing a PR? |
I'm afraid I don't have enough skills to try to make these code changes( |
@alexey-leonovich Is your example above using the same guid value? If not, could you provide an example that does? |
@ErikEJ sorry, missed your question somehow. |
How do you get from one to the other? |
or simply via https://toolslick.com/conversion/data/guid |
Thanks, I will consider implementing an option to use this format |
Hello.
If I use the following command to export my test SqlCe database to SQLite:
it creates insert statement where uniqueidentifier column data is inserted as text (e. g.
'65c6b3fd-e487-464a-bf79-fb3cebe9c9bf'
).Is it possible make it to create inserts as binary (e. g.
X'a8828ddfef224d36935a1c66ae86ebb3'
)?I've tried
Data Source=entities.sdf;BinaryGUID=True;
but looks like your tool doesn't understand that:Thank you.
The text was updated successfully, but these errors were encountered: