If you want to convert one SQLite version into another, use database conversion dialog. When editing database details it's not possible to change it's type (SQLite2, SQLite3, or any other), because this is allowed only when creating new datababase. It will not copy nor move the old database file to new location. When changing database file path, it will mean that under the same name you will access the new database file. The database name is just symbolic name, an alias used by SQLiteStudio to present database in the list. The standard database dialog will appear.Ĭhanging database's name is allowed as far, as the new name is unique across all databases being currently on the list. Just right-click on it and pick "Edit database" from context menu. You can edit database details at any moment. Managing database list Editing database details You can double-click on it to open it:Īlternatively you can use drag&drop mechanism: drag database file from your file manager and drop it onto the database list, then confirm the database dialog. Then click "Save" and "Ok" in next dialog and your database will be added to the list. In the file browsing dialog pick an existing database file: Then you click (just like before) on browse button: Repeat steps from above, util you see database dialog: Using existing databaseĪdding an existing database to the list is very similar to creating new database. If this option is not checked, then the databases will disappear from the list after SQLiteStudio was restarted. This means that when you close SQLiteStudio and start it again, the database will remain on the list. When this option is checked, then the database is added permanently to SQLiteStudio. You may have noticed the "Permanent" check in the database dialog:
You will see it in the databases list on the left: You can now press "Ok" to create the database. If there was any problem, the red icon will appear.
If everything is okay, than you will see green icon next to it:
#Sqlitestudio printing free#
You can press "Test connection" to make sure that your database file can be created in specified localisation (in regards of directory permissions, free space, etc). You can pick any name you want, it just has be unique in context of databases already added to SQLiteStudio. You can change the name to whatever you want (in which case you have to disable the checkbox on the right hand side), or just leave it as it is. Now the database dialog has file name and database name filled in. In this dialog go to directory where you want to create your database and type in the file name for your database (on the image above it's "test.db"). You will see filesystem browsing dialog (this may look different on various operating systems): Right-click on database list and pick entry from context menu:.You can create new database in three ways:
#Sqlitestudio printing code#
Installing binary package Installing from source code Installation and running Supported platforms Platform I'm using Fcitx input method, but it doesn't work in SQLiteStudio.I have saved binary data into SQLite 2 database, but now it's damaged, empty or truncated!.Moving and copying objects between databases.
0 kommentar(er)
