SSIS using Kingswaysoft

Question

SSIS using Kingswaysoft

Sachin Joshi 0

Hi Team,

I want to do the On prem CRM migration from 8.1 to 9.1 where we have a 9 TB SQL data which is the big challange for us. Someone suggested to do this using Kingswaysoft tool which handles a large data migration. Could you please provide us whether it is recommended by Microsoft. Also, Is there any other approach Microsoft suggested? Please waiting for your earliest reply.

Erland Sommarskog 127.7K Reputation points MVP Volunteer Moderator

2025-09-22T21:15:58.3+00:00

This "CRM" is this Dynamics CRM?

I am not all familiar with CRM, but it sounds funny to me that you would need to use SSIS to upgrade from one version of a product to another.

I am not all familiar with Kingswaysoft, but I would not expect that Microsoft recommends third-party products. Then again, if this upgrade really requires that heavy lifting, maybe the Dynamics team have some recommendations. I don't really know where you ask questions about Dynamics, but I don't think it is supported in Microsoft Q&A.

1 answer

Your answer

Erland Sommarskog 127.7K Reputation points MVP Volunteer Moderator

2025-09-22T21:15:58.3+00:00

This "CRM" is this Dynamics CRM?

I am not all familiar with CRM, but it sounds funny to me that you would need to use SSIS to upgrade from one version of a product to another.

I am not all familiar with Kingswaysoft, but I would not expect that Microsoft recommends third-party products. Then again, if this upgrade really requires that heavy lifting, maybe the Dynamics team have some recommendations. I don't really know where you ask questions about Dynamics, but I don't think it is supported in Microsoft Q&A.

Answer 1

Thank you for reaching out. Migrating from Dynamics CRM 8.1 to 9.1 with a 9 TB SQL database is a significant undertaking, and it's great that you're exploring KingswaySoft as a solution. Below is a step-by-step guide to help you proceed with the migration using SSIS and KingswaySoft:

Environment Setup

Prepare a dedicated VM with:
- SQL Server
  - Visual Studio (with SSIS)
    - KingswaySoft SSIS Integration Toolkit for Dynamics CRM
    - Ensure the target Dynamics 9.1 environment is ready and schema-aligned.

Data Assessment

Analyze the 9 TB SQL database:
- Identify entities and relationships.
  - Cleanse and deduplicate data.
    - Validate schema compatibility with Dynamics 9.1.

SSIS Package Design

Use KingswaySoft components:
- CRM Source Component to extract data.
  - CRM Destination Component to insert/update data.
    - Enable Upsert for efficient data handling.
      - Apply FetchXML filters for selective migration.

Performance Optimization

Set batch size between 200–500 records.
Enable multi-threading in KingswaySoft.
Disable plugins/workflows during migration.
Implement retry logic and error redirection.

Migration Execution

Run SSIS packages via Visual Studio or SQL Agent.
Monitor logs for success/failure.
Validate migrated data in Dynamics 9.1.

Post-Migration Validation

Verify record counts and relationships.
Re-enable plugins and workflows.
Conduct user acceptance testing (UAT).

Final Cutover

Schedule downtime if needed.
Perform final delta migration for recent changes.
Transition users to the new environment.

Let me know if the issue persists after following these steps. I’ll be happy to assist further if needed. If the issue has been resolved, please click "Accept Answer".

Gade Harika (INFOSYS LIMITED) 1,260 Reputation points Microsoft External Staff

2025-09-29T11:56:05.8033333+00:00

Hope you're doing well! Please let us know if the issue persists or resolved. If the answer is helpful, please click "Accept Answer" and kindly approve it. If we didn't get any response from your side. we will proceed to close the thread by October 6th.
Gade Harika (INFOSYS LIMITED) 1,260 Reputation points Microsoft External Staff

2025-10-01T08:48:40.7333333+00:00

Hope you're doing well! Please let us know if the issue persists or resolved. If the answer is helpful, please click "Accept Answer" and kindly approve it.
Gade Harika (INFOSYS LIMITED) 1,260 Reputation points Microsoft External Staff

2025-10-06T11:55:24.92+00:00

We haven’t received any further updates or follow-up on this case, so we’ll proceed with closing it at this time. If you require additional assistance or have new information to share, please feel free to raise new thread, we’re happy to support you further needed.

Share via

SSIS using Kingswaysoft

1 answer

Your answer