One of the most common error-solving methods for SQL Server importing exported data _mssql

Now the main use of the building station or ASP and PHP, the two languages commonly used in the database for SQL Server and MySQL, the two databases have their own strengths, but also say who good who bad, look at personal habits.

The purpose of the SQL Server Import and Export Wizard is to copy data from the source to the destination. The wizard can also create a target database and a target table for you. However, if you must copy multiple databases or tables, or you must copy other types of database objects, you should use the Copy Database Wizard instead.

Total failure in database import export, error message as follows:

Copy Code code as follows:

Validating (Error)
News
Error 0xc0202049: Data Flow Task 1: Unable to insert data in read-only column ' ID '.
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task 1: Validating column metadata failed.
(SQL Server Import and Export Wizard)
Error 0XC004706B: Data Flow Task 1: Component Target-t_*** "(34)" validation failed with the returned validation status of "Vs_isbroken".
(SQL Server Import and Export Wizard)
Error 0XC004700C: Data Flow Task 1: One or more components failed validation.
(SQL Server Import and Export Wizard)
Error 0XC0024107: Data Flow Task 1: Error during task validation.
(SQL Server Import and Export Wizard)

Workaround:

Import Export Wizard, on the Select source table and Source view page, click Edit Image after importing the exported table, select Enable Identity column insert