Skip to content
This repository has been archived by the owner on Sep 7, 2021. It is now read-only.
This repository is currently being migrated. It's locked while the migration is in progress.

SQLite to mssql dump #1426

Open
LukeMauldin opened this issue Sep 17, 2019 · 0 comments
Open

SQLite to mssql dump #1426

LukeMauldin opened this issue Sep 17, 2019 · 0 comments
Labels
kind/bug

Comments

@LukeMauldin
Copy link

Using gitea 1.9.3 which uses xorm for its database operations. Used gitea command line to export SQLite database into .sql file with “mssql” syntax.
Running .sql file fails on MSSQL server because Boolean columns are exported with the values of “true” and “false” whereas MSSQL requires Boolean fields to use the values 1 and 0.
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
kind/bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@lunny @LukeMauldin