I have a staging environment that I have been testing out sync rules with. What is the best way to clear out the metaverse and connector space database without reinstalling and recreating the database? I think doing a full import leaves some residual data. I want to clear everything out and do a full import\full synch from scratch.

Hi Mishua, Thank you for asking this question on the Microsoft Q&A Platform. I came across this script and will be using it my lab however it does the job as per the Github repo, so please review this and try out. DataSyncMetadataCleanup If it does not map your requirements, I will suggest you can raise a support ticket with Microsoft. == Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Deleting the connector spaces seems to do to the trick.

Clear ADsync database - Microsoft Q&A

Accepted answer

JimmySalian-2011 41,926 Reputation points

2022-08-23T18:22:24.42+00:00

Hi Mishua,

Thank you for asking this question on the Microsoft Q&A Platform.

I came across this script and will be using it my lab however it does the job as per the Github repo, so please review this and try out.
DataSyncMetadataCleanup

If it does not map your requirements, I will suggest you can raise a support ticket with Microsoft.

==
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.
Please sign in to rate this answer.

1 person found this answer helpful.
Mishaua 716 Reputation points

2022-08-23T21:07:02.557+00:00

@JimmySalian-2011 Thanks for the link but I think this is a bigger hammer than I am comfortable using. The sql queries seem to reference sys databases and not just the adsync database. I remember seeing something about recreating connectors, and something mentioning cache. I basically just want to delete all the objects and fully import again.

JimmySalian-2011 41,926 Reputation points

2022-08-24T10:36:43.297+00:00

Hi,

I think you can backup the configuration and export to csv, deleting the connector is the option I can think of

The option Delete connector space only removes all data, but keep the configuration.

The option Delete Connector and connector space removes the data, the configuration and all the sync rules associated with the connector. This option is used when you do not want to connect to a forest anymore.

However you will need to reconfigure the connectors and import the data. Best way or approach will be carry this in Dev Test Env.

==
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.
Sign in to comment

Clear ADsync database

1 additional answer