SQLite to mssql dump #1426

New Issue

lunny · 2019-09-17T18:17:37Z

LukeMauldin commented

2019-09-17 18:17:37 +00:00

(Migrated from github.com)

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.

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.

lunny added this to the 1.1.1 milestone 2020-03-04 02:17:53 +00:00

lunny modified the milestone from 1.1.1 to 1.0.3

2020-07-09 01:42:09 +00:00

lunny commented

2020-07-09 01:48:46 +00:00

fixed by #1639

lunny closed this issue

2020-07-09 01:48:47 +00:00

Sign in to join this conversation.

No Milestone

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#1426