This topic is locked
[SOLVED]

 Database Won't Sync

4/23/2019 7:30:08 PM
ASPRunner.NET General questions
M
Mack88 authorDevClub member

Hi All,
I am developing an app using ASPR 10.1 Enterprise build 32765 and SQL Express 2012. All was fine until a couple of days ago when I made some changes to the structure of one table. When I manually sync'd the database, I noticed that some of the deleted fields were still present in the table. I'm early in the development with a short deadline, so my fix was to recreate the app. Seems a blunt tool, though.
Has anyone else experienced this weird behaviour and have some troubleshooting tips?
Thanks in advance
Chris

A
Arkie 4/25/2019

I had a small problem with an SQL db once, but I was early in the game so, like you, I just started over.
But I've often wondered what caused my db to crash. In that particular case I made some changes direct to the SQL db using a MySQL utility. At other times, I've made small changes but doing so within the ASPRunner interface without any problems.
How did you make your changes? An SQL utility or within ASPRunner.
btw... I don't know what difference that it might make, but I don't use the Enterprise version

Pete K 4/26/2019

I've noticed on occasion when I make minor changes to a database and then sync with ASPR, the changes don't get picked up. But it usually catches up on a later sync. I've never had a situation where it didn't eventually sync up.

M
Mack88 authorDevClub member 5/1/2019

Thanks for the replies.
I've done a little digging. It seems that some of the changes flow through to the pages but the table page doesn't always update. My current workaround is to manually edit the field names/specs as necessary. So far, it seems to work okay, but my fingers are still crossed. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=87677&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

admin 5/2/2019

After you made changes to database structure and synchronize database make sure you manually adjust SQL query to accommodate for those changes. SQL Query is the ultimate source of the fields that appear on all other pages.

M
Mack88 authorDevClub member 5/2/2019



After you made changes to database structure and synchronize database make sure you manually adjust SQL query to accommodate for those changes. SQL Query is the ultimate source of the fields that appear on all other pages.


Thanks Sergey. I'll keep that in mind.
Chris