Jump to content
Server Maintenance This Week. ×

Empty a Spoke Table?


This topic is 505 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Is it possible to empty a single Table on the Spoke when using Bi-Rectional syncing?

I want to ensure a refresh on the spoke sometimes, but not for all the tables as the DB is very large.

I could go and empty the spoke table manually BUT that will cause all the records to be deleted on the Host next time it syncs.

I know I can do "Delete Spoke", but that will do ALL the tables... I only want to do specific a table(s).

Is this possible?

Link to comment
Share on other sites

You could use the sync itself to delete the records on the spoke.

Flag the records on the server and filter them in the mirrorsync script.

Records will be deleted on the spoke but kept on the server.

Link to comment
Share on other sites

Have to give you credit for an inventive way of doing it  :)  

I was hoping there might be an official method which wouldn't be as labour intensive as the find/delete.

Thanks for the idea, I'll see if I can use that to get something working.

 

 

Link to comment
Share on other sites

This topic is 505 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.