Is there an easy way to remove an entire ARS table and replace it with a new one?
In addition to the core site, I have a eight remote locations. Each remote location has an ARS table. There is a very large ALL table, but oddly no loc 1 table.
I'll spare the details, but suffice to say there is quite a mess - redundancies, inefficiencies, etc. Ugly as it is, it largely works - except for the occasional BCP snafu.
It seems to me the easiest way to clean it up will be to export all the tables and create a new table for each location. Then import the new table and delete/replace the old one. I use GEDI all the time to export data, but have never tried to import data. Not sure if/how that would work.
Thanks in advance for any help/suggestions.
In addition to the core site, I have a eight remote locations. Each remote location has an ARS table. There is a very large ALL table, but oddly no loc 1 table.
I'll spare the details, but suffice to say there is quite a mess - redundancies, inefficiencies, etc. Ugly as it is, it largely works - except for the occasional BCP snafu.
It seems to me the easiest way to clean it up will be to export all the tables and create a new table for each location. Then import the new table and delete/replace the old one. I use GEDI all the time to export data, but have never tried to import data. Not sure if/how that would work.
Thanks in advance for any help/suggestions.