# Refreshing remote DB schema **URL:** \ **Category:** Schema & Data\ **Created:** [August 25, 2014, 4:27pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288 "2014-08-25T16:27:08Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![cmcculler](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/cmcculler/32/108_2.png) [@cmcculler](https://community.dreamfactory.com/u/cmcculler)\ **Post date:** [August 25, 2014, 4:27pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288/1 "2014-08-25T16:27:09Z")
I’m stubbing out an application with a MSSQL backend and the schema is constantly changing as I implement more features and it’s hard to get the schema to update on-demand. There is an [issue] ([https://github.com/dreamfactorysoftware/dsp-core/issues/11](https://github.com/dreamfactorysoftware/dsp-core/issues/11)) on the dsp-core project on GitHub for this that hasn’t seen an update since March 15. Is the solution on that issue still a viable method or is there a better way now? ---
**Author:** ![Mark](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/mark/32/69_2.png) [@Mark](https://community.dreamfactory.com/u/Mark)\ **Post date:** [August 27, 2014, 11:03pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288/2 "2014-08-27T23:03:36Z")
Hey - a similar issue popped up in the past when a user was using two mySQL db’s. One of the db’s was set to refresh first while the other’s refresh rate was much slower. Have you tried to do the “rebuild swagger cache” when you want the db schema to be updated? Give that a try - thanks, Mark ---
**Author:** ![Mark](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/mark/32/69_2.png) [@Mark](https://community.dreamfactory.com/u/Mark)\ **Post date:** [August 27, 2014, 11:04pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288/3 "2014-08-27T23:04:17Z")
Hey - a similar issue popped up in the past when a user was using two mySQL db’s. One of the db’s was set to refresh first while the other’s refresh rate was much slower. Have you tried to do the “rebuild swagger cache” when you want the db schema to be updated? Give that a try - thanks, Mark ---
**Author:** ![cmcculler](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/cmcculler/32/108_2.png) [@cmcculler](https://community.dreamfactory.com/u/cmcculler)\ **Post date:** [August 27, 2014, 11:52pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288/4 "2014-08-27T23:52:37Z")
@Mark I have tried that and it did not work. Turns out there is a bug with the Refresh flag that causes it to not refresh all the time. @leehicks and @Jason are aware of it and were working on a fix as of 8/25. The schema cache looks like it has a timeout of about an hour so I was able to get my issue resolved by finalizing my schema then refreshing the schema after the timeout period. ---
**Author:** ![praveen](https://avatars.discourse-cdn.com/v4/letter/p/3ec8ea/32.png) [@praveen](https://community.dreamfactory.com/u/praveen)\ **Post date:** [October 29, 2014, 12:15pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288/5 "2014-10-29T12:15:39Z")
Any updates on this one? Has this issue been resolved? ---
**Author:** ![cmcculler](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/cmcculler/32/108_2.png) [@cmcculler](https://community.dreamfactory.com/u/cmcculler)\ **Post date:** [October 29, 2014, 12:34pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288/6 "2014-10-29T12:34:34Z")
This has been resolved for me since 1.7.8 I believe. Currently on 1.8.0 and it’s working for me. ---
**Author:** ![praveen](https://avatars.discourse-cdn.com/v4/letter/p/3ec8ea/32.png) [@praveen](https://community.dreamfactory.com/u/praveen)\ **Post date:** [October 29, 2014, 1:41pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288/7 "2014-10-29T13:41:11Z")
Strangely, I am facing the issue of my Remote DB’s views don’t reflect immediately. It does reflect after a random period of time, which I am not aware of. May be 30-40 mins. How do you reflect the changes immediately. Were you facing issues with schema, table or views? I am on 1.8.0 ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [October 29, 2014, 3:56pm UTC](https://community.dreamfactory.com/t/refreshing-remote-db-schema/288/8 "2014-10-29T15:56:32Z")
> [@PostGreSQL Views don't refresh](https://community.dreamfactory.com/t/postgresql-views-dont-refresh/511/): > > DSP does not refresh the schema as it ideally should. I have tried to Flush Platform Cache and Rebuild Swagger Cache but it doesn’t work. Logging out does not working either. Then suddenly after a long period, I see the Views get shown. Isn’t there a sure shot method which can ensure that the view gets reflected in the DSP itself. I clearly have my views in the DB, but not getting shown on the DSP.