Mssql dump import #3931

Closed
opened 2025-11-02 05:31:00 -06:00 by GiteaMirror · 2 comments
Owner

Originally created by @LukeMauldin on GitHub (Sep 10, 2019).

  • Gitea version (or commit ref): 1.9.3
  • Git version: 2.18
  • Operating system: Windows
  • Database (use [x]):
    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • [x ] Not relevant
  • Log gist:

Description

Current using sqlite as gitea database and want to transition to mssql. Ran ‘gitea dump —database mssql’ but encountered errors when trying to import .sql file.
The problem is that is .sql file uses the literal values of “true” and “false” for Boolean columns. Mssql requires the use of 1 and 0 for Boolean columns.

Originally created by @LukeMauldin on GitHub (Sep 10, 2019). - Gitea version (or commit ref): 1.9.3 - Git version: 2.18 - Operating system: Windows - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [x] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [x ] Not relevant - Log gist: ## Description Current using sqlite as gitea database and want to transition to mssql. Ran ‘gitea dump —database mssql’ but encountered errors when trying to import .sql file. The problem is that is .sql file uses the literal values of “true” and “false” for Boolean columns. Mssql requires the use of 1 and 0 for Boolean columns.
GiteaMirror added the status/blockedtype/upstream labels 2025-11-02 05:31:00 -06:00
Author
Owner

@techknowlogick commented on GitHub (Sep 11, 2019):

Would you be able to file an upstream bug report for this? We use https://github.com/go-xorm/xorm for database operations.

@techknowlogick commented on GitHub (Sep 11, 2019): Would you be able to file an upstream bug report for this? We use https://github.com/go-xorm/xorm for database operations.
Author
Owner

@LukeMauldin commented on GitHub (Sep 17, 2019):

Created issue https://github.com/go-xorm/xorm/issues/1426

@LukeMauldin commented on GitHub (Sep 17, 2019): Created issue https://github.com/go-xorm/xorm/issues/1426
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#3931