Write error during migration from Ctree/Btrieve to MSSQL

Article ID: 871907
Expand all | Collapse all

TechKnowledge Content

Question:

I am migrating a large data set to Dynamics from ctree/btrieve to Dynamics on Microsoft SQL. During the migration, several of my files failed to migrate and the only error I receive is a write error. What is a 'write error'?

Answer:

During a migration to MSSQL, if the MSSQL database is not created large enough to accommodate the existing data, and it is has been selected to dynamically grow your database, the migration application may fail on a file with a 'write error' if the database is not growing fast enough. The MSSQL database should be set to a specified size of 1.5 to 2 times the Ctree/Btrieve database during the migration. To change how the database is grown, open Enterprise Manager and select your database. Right click, choose Properties - Data file. Under the Space Allocated column, specify the file size of 1.5 to 2 times the size of the database you are migrating from. Then remigrate the tables that did not migrate. After the migration you can select to dynamically grow your database again.




This article was TechKnowledge Document ID: 21627

Properties

Article ID: 871907 - Last Review: October 15, 2011 - Revision: 3.0
Keywords: 
kbmbsmigrate kbretire KB871907
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com