a way to convert sqlite to mssql #3959

New Issue

GiteaMirror · 2025-11-02T05:31:48-06:00

GiteaMirror commented

2025-11-02 05:31:48 -06:00

Originally created by @zuhairamahdi on GitHub (Sep 15, 2019).

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

Description

Hi,

we are migrating from sqlite to MSSQL server. though now we are having a difficulties converting the gitea.db to the MSSQL formate

Screenshots

Originally created by @zuhairamahdi on GitHub (Sep 15, 2019).   - Gitea version (or commit ref): - Git version: - Operating system: - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [x] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [ ] Not relevant - Log gist: ## Description Hi, we are migrating from sqlite to MSSQL server. though now we are having a difficulties converting the `gitea.db` to the MSSQL formate ## Screenshots

GiteaMirror added the type/question label 2025-11-02 05:31:48 -06:00

GiteaMirror closed this issue

2025-11-02 05:31:48 -06:00

GiteaMirror commented

2025-11-02 05:31:49 -06:00

@jaqra commented on GitHub (Sep 16, 2019):

Can you check this question & answers?

https://stackoverflow.com/questions/163079/exporting-from-sqlite-to-sql-server

@jaqra commented on GitHub (Sep 16, 2019): Can you check this question & answers? https://stackoverflow.com/questions/163079/exporting-from-sqlite-to-sql-server

GiteaMirror commented

2025-11-02 05:31:49 -06:00

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

@jaqra That's a common subject. I think there are many tools could move data from sqlite to sql server.

@lunny commented on GitHub (Sep 17, 2019): @jaqra That's a common subject. I think there are many tools could move data from sqlite to sql server.

GiteaMirror commented

2025-11-02 05:31:49 -06:00

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

the issue mostly is with creating the tables and keeping the indexing. I worked around this issue by creating a new instance of gitea to create the wanted database structure and then migrate the data to it. even with that there is a lot of manual work to be done for it to work.

@zuhairamahdi commented on GitHub (Sep 17, 2019): the issue mostly is with creating the tables and keeping the indexing. I worked around this issue by creating a new instance of gitea to create the wanted database structure and then migrate the data to it. even with that there is a lot of manual work to be done for it to work.

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/gitea#3959