Forum Discussion
Push Dataset create table API
My experience is that it is faster to start over. Prepare the meta data for both tables, and then (re)fill them. You can use SSMS if that's more convenient for you.
What do you mean by starting over again? When the push dataset already exists, how can we start over without losing any settings/permissions we have already done?
The scenario is like we have two production machines that collect data in different intervalls, lets say every 10 seconds for machine1 and every 20 seconds for machine2. That are the two tables that already exists. We push data to these two tables via API over the day and delete the data once every night and refill them with the last 4 hours of data.
How to add another table for one more machine (machine3) that collects data every 30 seconds?
delete all tables and then submit a single combined request to create the new table structures. Then fill these new tables.
You may be trying to use push datasets in a way that they were not designed for. You may want to look at alternatives like streaming datasets.
... submit a single combined request to create the new table structures
That is exactly my trouble. The question is: HOW to create the new table structures?
