Extend the database

Scriptcase 8 Discussion
#1

Hi

If I after deploying extend the database (new fields), how do I update the project have already been published?
The SQL database needs to be updated on the remote server too.

Bye
Mansaylon

#2

Hello Mansoy
Yes, you need make the same changes in the remove server too. ScriptCase will not recognize the new structure with magic and then generates the new files that are not presented.

#3

So I have to export the new SQL structure with PHPMyAdmin and import on the active remote Server? Or is there an other way?
That was really the question.

#4

This will not work as is, because your export is a new structure, not the modification of an existing structure. You have to track changes on SQL since the deployed version. Another option…I think MySQL replication has this ability, but depending of the size of your project, is like kill flies with cannons. There are commercial tools too to do it for you automatically, creating a diff SQL for you, comparing structures.Contact with me by PM if you are interested.

#5

in PHPMyAdmin you’ll see the sql-statements you’ve been using like ‘ALTER TABLE …;’

Save it into a txt-file and aply them on your production-databases

#6

I use 3rd party SQLyog.

#7

Both SQLYog and Navicat will allow you the either create the SQL statements or actually synchronize the structure of the tables between what you have locally and what’s on the server.