www.webdeveloper.com
Results 1 to 5 of 5

Thread: Dev and Production Site Syncronization

  1. #1
    Join Date
    Jan 2005
    Posts
    361

    Dev and Production Site Syncronization

    hey, wow been so long i haven't visit this forum but hopefully some one would have intake on what im looking for

    Im trying to figure out solution for safe development for continuously improving site. So i have Production site, i want to have development and MergeTest site running say on subdaomain. All work is done on Dev box then we copy current state of production to Merge Box, then we try to update Dev code and database to e Merge box if after update merge box is not showing any issues we run same update on production server.

    I think that's reasonable deployment solution but i have no idea how to make it happen (i mean automate it)

    Im running LAMP environment.

    Any ideas?

  2. #2
    Join Date
    Aug 2014
    Posts
    12
    I guess you can use Fabric. It's awesome deploy program.
    You need to write a script first. Then you can execute for example like this:
    fab deploy dev - this will upload your dev version of the site to subdomain
    fab deploy MergeTest - this will update your dev version to MergeTest
    fab deploy production - this can upload your site to production.

    Also you can execute some tests before or after fab deploy MergeTest. Fabric is very flexible and has a good documentation. I hope you'll like it.

  3. #3
    Join Date
    Jan 2005
    Posts
    361
    tnx a lot i will check out that project
    ------
    What am I doing?

  4. #4
    Join Date
    Sep 2014
    Posts
    6
    If you write your SQL statements for your development database (which are, I imagine, series of DDL instructions such as CREATE, ALTER and DROP), why don't you keep track of them by recording them in a table, with a "version" index? You will then be able to:

    track your version changes
    make a small routine allowing the "automatic" update of your production database by sending the recorded instructions to the database.

  5. #5
    Join Date
    Jan 2005
    Posts
    361
    as to database, if thas done manually then there is a degree of error that can be produced by one of the programmer forgetting to log the change of the structure
    ------
    What am I doing?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles