Assuming that it is necessary to delete data only from some tables for example for a Go-live (I remember that in Business Central Online – SaaS cannot access the database in any way, I do not like this thing but it is so).
Don’t Panic… Keep calm and GO LIVE! You have two methods to achieve this goal.
#1 – OPEN IN EXCEL: It does not allow deleting everything, only some tables, for example it is not possible to delete tables with transactional data (non-sense and very large time consuming). It is the only mode officially provided by Microsoft embedded with the pages.
#2 Go-LIVE Tool CUSTOM EXTENSION: Create and install a dedicated extension (for example, creating a delete report or a table selection mask and assigning the necessary permissions). In this case I modified one of the old GO-LIVE tools already existing (there are a couple of versions of it) adapting it to BC Online, in this case that of Olof Simren. Remember that it is to be used with discretion, only in the test \ setup environments … NOT on the production db of course.
As said is the solution proposed by Microsoft, waiting for other tools \ kit etc.
You can delete data directly from Excel, deleting each records, Publish and it works, we have NO more customers in my database.
And the Customer table is Empty!
As I said, I created this very simple extension that allows you to erase the data from the chosen Tables, based on one of the already existing Go-Live tools; it’s a very simple, improvable app, useful for quickly deleting data.
For example, some methods or system tables that are locked ByDesign and cannot be used (for system security and integrity); I could not therefore use some methods or table ex: “table information”, DELETE Method is obviously allowed.
Is only permitted to publish the “Objects” and “Fields” Virtual tables AS Web Services, if you need to recover tabled and fields Names from these.
AND RUN “Delete Records Page”!
Example: tbl 32, 17, 21, 25, etc. manually inserrted.
You can import tables using RapidStart Services (a package wth all tables to delete), loaded from an Excel List for example.
..AND WAIT SOME MINUTES.. ALL THE TABLES LISTED IN PAGE WILL BE DELETED.
IF The System “Hangs Up” or NOT complete the deletions… don’t warry…. you can run more times!