1. Jochen Peters
  2. as SQLite DB Server
  3. Thursday, March 31 2016, 12:39 AM
  4.  Subscribe via email
Hi
Who i import PostgreSQL DataBase to Valentina Sqlite Server
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hi, Alexis

Currently a database schema (structure) migration can be done manually via the SQL script.

Dump PostgreSQL structure to SQL and correct it to match the SQLite rules:
* remove schemas definitions
* rename field types appropriately, it is necessary, because SQLite allows to set any field type name

Create a new SQLite database and load resulting corrected SQL dump into it.

To migrate records - Data Transfer tool can be used.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories