Announcement

Collapse
No announcement yet.

Extend the database

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Extend the database

    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.

    Comment


    • #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.

      Comment


      • #4
        Originally posted by Mansaylon View Post
        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.
        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.
        /Giuseppe

        Professional Scriptcase Services
        Some Customers opinions

        Comment


        • #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

          Comment


          • #6
            I use 3rd party SQLyog.

            Comment


            • #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.

              Comment

              Working...
              X