Hello, I recently performed a deployment to production on 5/7 for an application. I was made aware that all records in a particular table from the time of deployment back to the first record were missing and that only records from 5/7-present are available.
I logged into the SQL Server to look at the tables and found that there were now two versions of the table, the original having all data before 5/7 and the new table with 5/7-present
Looks like your developer deleted the entity ( Cut + Paste ) which created a new entity. Good part is you have access to SQL Server as it is on premise installation and you have to manually merge data. btw I don't think you can use the first table.
Thank you for the response - I was tinkering with a different version of the table and may have mistakenly cut-and-pasted the table. Lesson learned!
Hi John Bradley ,
That situation happens when you delete the entity in the Data tab and create again with the same name(for instance cut and paste).
In the Data Tab the name would be the same but after publishing internally it would inactivate the previous table and create a new physical table in the database.
Regards,