You can export the system database from dev instance and import in to prod db server.
Before import edit the ‘create’ statement in the .sql file to use another database name and save the changes to the .sql file. Next import the database in to the PHPMyAdmin or other SQL tool for the prod Dreamfactory instance and create a default database user and password for the newly imported database.
Copy the app_key from the dev .env file and replace the app_key in the prod .env to ensure you can retrieve any hashed database values and prevent token signature errors.
At this point also edit the .env file to point to the database you’ve just imported as well as employ the user you’ve just created. Then follow the steps as described here:
Once the prod instance is pointed to the new database run the following commands:
php artisan migrate --seed
php artisan dreamfactory:service-type-migrate
php artisan clear-compiled
php artisan cache:clear
php artisan optimize
Restart the web server and check that the services,roles,user and scripts etc… are showing up.