Platformus icon indicating copy to clipboard operation
Platformus copied to clipboard

2.0 SQL Database changes

Open senadburak opened this issue 3 years ago • 2 comments

Hi Dmitry, thanks to the new 2.0 blog sample I finally managed my site to work... well, kind of. The problem is I am still unable to use my old Platformus 1.0 MS SQL database with the new 2.0 system. If I use newly created Platformus 2.0 database, all works perfectly. Of course, I want to use my old (pretty big) 1.0 database. I tried to see what are the changes in the new SQL Server schema and implemented them into my database, but still no luck. Obviously, I missed something.

Could you please explain what we need to add/modify in Platformus 1.0 SQL Server database in order to be compatible with the new 2.0 platform. I am sure I am not the only one with this problem

By the way, excellent job on new 2.0.

senadburak avatar Mar 29 '21 20:03 senadburak

Hi @senadburak , sorry for so many changes, I'm constantly reviewing the project and trying to make it simpler. You need to remove everything that start from "Serialized..." from the DB. There are also a few small changes like renamed properties.

Also, Id property type is changed in the Localizations table. Now it is just a two-letter country code.

DmitrySikorsky avatar Aug 16 '21 14:08 DmitrySikorsky

Now I'm working on the docs, but I'm not sure I will be able to write a good migration article.

DmitrySikorsky avatar Aug 16 '21 14:08 DmitrySikorsky