mORMot Open Source

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 516

Question: HowTo easily Migrate Database from SQLite to MS-SQL external

Hi Arnaud,

is there a simple mechanism to migrate from internal SQLite Database to external MS-SQL (or Other) Database ?
For Example Backup in SQLite Version and Restore in MS-SQL Version ?

Last edited by itSDS (2016-01-16 11:36:48)

---

Rad Studio 12.1 Santorini

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,666

Website

Re: Question: HowTo easily Migrate Database from SQLite to MS-SQL external

There is no such embedded mechanism yet, but it would be pretty easy using the ORM.
Create two TSQLRestServer instances, and copy the old content objects into the new server, using batches.
Could be written with very little code, even in an abstract way, for any TSQLRecord type.