# Move an app and its schema etc to another DSP **URL:** \ **Category:** Schema & Data\ **Created:** [November 20, 2014, 12:53am UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557 "2014-11-20T00:53:09Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![greywire](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/greywire/32/135_2.png) [@greywire](https://community.dreamfactory.com/u/greywire)\ **Post date:** [November 20, 2014, 12:53am UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557/1 "2014-11-20T00:53:09Z")
If I develop an app on the hosted DSP but then I need to deploy it to a client on their own DSP, is there an easy way to move the schema and data, security settings, etc to another DSP? ---
**Author:** ![benbusse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/benbusse/32/4_2.png) [@benbusse](https://community.dreamfactory.com/u/benbusse)\ **Post date:** [November 20, 2014, 1:11am UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557/2 "2014-11-20T01:11:10Z")
Yes, just go to the Packages tab and select the apps, schema, and services (APIs) you want to export. Then import this file into the client’s DSP by clicking the Import button in the Apps tab. ---
**Author:** ![greywire](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/greywire/32/135_2.png) [@greywire](https://community.dreamfactory.com/u/greywire)\ **Post date:** [November 20, 2014, 2:41am UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557/3 "2014-11-20T02:41:24Z")
That’s what I thought but I’m not seeing schemas listed ---
**Author:** ![benbusse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/benbusse/32/4_2.png) [@benbusse](https://community.dreamfactory.com/u/benbusse)\ **Post date:** [November 20, 2014, 5:06am UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557/4 "2014-11-20T05:06:26Z")
When you click on an app, you should see a list of tables (schema) that you can select. Note that these tables are for the MySQL DB that’s part of DreamFactory (accessed by the /db API). If you’re connecting to a remote SQL or NoSQL database, you won’t see the schema listed since the database is remote. ---
**Author:** ![greywire](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/greywire/32/135_2.png) [@greywire](https://community.dreamfactory.com/u/greywire)\ **Post date:** [November 20, 2014, 6:00pm UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557/5 "2014-11-20T18:00:19Z")
I dont see the database tables defined in the schema section. This is on both the dreamfactory hosted DSP as well a DSP setup on my local box. [This image is no longer available] ---
**Author:** ![benbusse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/benbusse/32/4_2.png) [@benbusse](https://community.dreamfactory.com/u/benbusse)\ **Post date:** [November 21, 2014, 1:39am UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557/6 "2014-11-21T01:39:02Z")
OK, I’m seeing schema in my hosted DSP but not in my local installation. Let me get back to you on this. ---
**Author:** ![benbusse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/benbusse/32/4_2.png) [@benbusse](https://community.dreamfactory.com/u/benbusse)\ **Post date:** [November 21, 2014, 5:35pm UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557/7 "2014-11-21T17:35:22Z")
I see the problem. The code is looking for the old ‘SQL DB Schema’ service which has been deprecated. So older DSPs work but the code needs to change to handle the new way. Working on a patch now, sorry about that. ---
**Author:** ![benbusse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/benbusse/32/4_2.png) [@benbusse](https://community.dreamfactory.com/u/benbusse)\ **Post date:** [November 24, 2014, 3:58pm UTC](https://community.dreamfactory.com/t/move-an-app-and-its-schema-etc-to-another-dsp/557/8 "2014-11-24T15:58:23Z")
A fix for this issue will be in the next release, coming up pretty soon.