3 Replies Latest reply on Nov 8, 2013 1:12 AM by Scott Wesley

    refreshing Dev workspace from Prod




      I suport an APEX app that has one workspace for Development and one for the live Production application.  When I originally created the Dev instance I was able to copy tables and data by granting select privileges between the two workspaces (I did this one table at a time).  The development workspace data needs to be refreshed from production since it's been a long time since the initial refresh and is very out of date.


      I would like to do a couple things:

      1) execute SQL to compare the tables in the two workspaces to ensure they're structurally identical

      2) execute SQL to truncate Dev tables and refresh from Prod


      Is there a way to do this?  Suggestions?