Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Bulk record deletion in CRM RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have a (probably) basic question about CRM and record deletion. I used Data Migration Manager to import data into my CRM. I would however like to wipe the records clean and have a completely blank system but with all the entities as I've set them up.

    Could you advise as to how I delete a large set of records. I can view the data and delete it but only (at best) 250 records. I'd like to know how to do this through the CRM interface if at all possible, but any suggestions are very much welcome.

    I'd like something similar to MySQL's "TRUNCATE Table"

    TIA, C

    Friday, September 24, 2010 11:24 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    My suggestion would be to create a simple .Net application using SDK to delete all records from entity. I belive it will not take too much time to delevelp this utility :)

     

    • Marked as answer by C.Harding Tuesday, October 12, 2010 8:52 AM
    Saturday, September 25, 2010 9:37 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    CRM doesn't provide a way to bulk delete records via the application. However, if you imported data using the Data Migration Manager it provides an option to delete data that was migrated (i.e. imported). SO start Data Migration Manager, click Delete Data and look for your migration job.

    An alternative is to export all customizations from your current CRM organization, then use the CRM Deployment Manager to create a new organization which will have no data and then import the customizations to the new database.

     

     

    Friday, September 24, 2010 11:40 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    For bulk deleting records not related to data import, you can use the CRM SDK's BulkDelete request.

    http://msdn.microsoft.com/en-us/library/cc151194.aspx

    Saturday, September 25, 2010 1:04 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    My suggestion would be to create a simple .Net application using SDK to delete all records from entity. I belive it will not take too much time to delevelp this utility :)

     

    • Marked as answer by C.Harding Tuesday, October 12, 2010 8:52 AM
    Saturday, September 25, 2010 9:37 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    In order to do this I did find the quickest way to ensure that my set of records were deleted, leaving behind the entities and their relationships was to use a bespoke deletion app using the CRM web services
    Tuesday, October 12, 2010 8:54 AM