Migrating From 2.2 to 2.3+

Introduction

A database created on Starcounter 2.2 is not compatible with Starcounter version 2.3. Thus, an application created on Starcounter 2.2 will have to have its data migrated to work properly.

The StarDump Tool

In Starcounter 2.3 and 2.4 the old staradmin unload and staradmin reload commands have been replaced with a new tool - StarDump.
The tool is available from the installation folder starting from 2.4.0.369 and 2.3.0.5427 Starcounter versions. By default the StarDump tool is located in C:\Program Files\Starcounter\stardump folder.
The StarDump tool unloads Starcounter database into an SQLite dump. The dump file can be viewed or modified by any tool compatible with SQLite. The recommended tool is - DB Browser for SQLite.

Usage

Unload Database

1
StarDump.exe unload --database [DatabaseName] --file [FilePath]
Copied!
Example
1
StarDump.exe unload --database default --file C:\Temp\default.sqlite3
Copied!

Reload Database

Before upgrading from 2.2 in order to reload, delete the directory at \<User>\Documents\Starcounter since it is not compatible with 2.3+. Warning! this will delete all the database files, ensure that it's properly backed up first.
1
StarDump.exe reload --database [DatabaseName] --file [FilePath]
Copied!
Example
1
StarDump.exe reload --database default --file C:\Temp\default.sqlite3
Copied!
Note: the database should be dropped and created prior to reload.
1
staradmin -d=default delete --force db
2
staradmin -d=default new db DefaultUserHttpPort=8080
Copied!

Migrating From Starcounter 2.2

The StarDump.Migrator.2.2 app produces an SQLite dump from Starcounter 2.2 database.
Things to know about StarDump.Migrator.2.2.
  • It is only compatible with Starcounter 2.2 and won't work with 2.3 or 2.4.
  • It is a Starcounter app which has to be started the same way as any other apps do.
  • It is not able to reload database dump, only unload.
  • All the apps defining [Database] classes should be started prior to unload with StarDump.Migrator.2.2 app.

Usage

  1. 1.
    Start database.
  2. 2.
    Start all of the applications which contains classes marked with [Database] attribute.
  3. 3.
    Start StarDump.Migrator.2.2.
  4. 4.
    Execute http://localhost:8080/StarDump/Migrator22/Unload/{FilePath}.
Example
1
http://localhost:8080/StarDump/Migrator22/Unload/D:/Temp/default.sqlite3
Copied!
The produced SQLite dump is compatible with the StarDump tool and can be used to reload database into Starcounter 2.3 or higher.
Note: the tools are in alpha stage and crashes are expected. Please use the StarDump and StarDump.Migrator.2.2 repositories to report any issue found.

Migrating From Starcounter 2.3.1 to 2.3.2 troubleshooting

During migration from Starcounter 2.3.1 to version 2.3.2 you can experience errors about missmatching schemas. Those are aftermaths of changes in data-model schema that were made during 2.3.1 version development. To fix those errors you can manually run those commands in the administrator SQL command line:
1
ALTER TABLE Starcounter.HtmlViewAttachment DROP COLUMN AttachedViewUri
2
ALTER TABLE Starcounter.HtmlViewComposition DROP COLUMN MainViewUri
3
ALTER TABLE Starcounter.HtmlViewComposition DROP COLUMN Version
Copied!
Last modified 3yr ago