How to transfer a native SQL Sever database to a virtual host SQL database

Many webmaster's website is Asp+access's website because the operation Access database website is very simple, even if you do not understand the database to be possible but if is the MSSQL database website, some novice friend does not know how to get here to do a simple use tutorial for everybody,  Mainly explains how to transfer our native SQL sever data to your space server sqlsever (of course, here can also transfer other virtual host server above the MSSQL, the method is the same, if the machine must be equipped with SQL2000) Because the forum already has several video tutorials to explain how to restore and attach the database, here I will no longer explain these, and give you how to let the import data (MSSQL site to use a good database is basically the 3 operations: Database restore, database attach, data import)

1, to operate, first we need to know our MSSQL product database user name and password, these can consult your space service provider next, you must set the remote access IP (this is your extranet IP) before you can connect successfully to the local Remote connection server SQL2000. Get the user name and password down we have to transfer our native SQL data to the server (of course, here can also transfer other virtual host server above the MSSQL, the method is the same, if the machine must be equipped with SQL2000)

2, Next, transfer our native SQL data to the server. Open our native Enterprise Manager to create a new SQL registration.

3. Select I want to not use the wizard in the future when I perform a task change

4, determined after the network speed some members may be slow to enter after choosing their own database (select someone else's database without any operational rights)

5, select the data to import native SQL data or other servers

6, next fill in your space server Mssqsql database related information, the above selected data will be imported into this database

During the transfer process, the following errors sometimes occur.

Error 0xc0202049: Data Flow Task: Unable to insert data in read-only column ' ID '
Issue: Import B database from a database The following error occurred

Verifying (Error)

News
Error 0xc0202049: Data Flow Task: Unable to insert data in read-only column ' ID '.
(SQL Server Import and Export Wizard)

Error 0xc0202045: Data Flow task: Validating column metadata failed.
(SQL Server Import and Export Wizard)

Error 0XC004706B: Data Flow Task: "Component" target-Activity "(55)" validation failed with the returned validation status "Vs_isbroken".
(SQL Server Import and Export Wizard)

Error 0XC004700C: Data Flow task: One or more components failed validation.
(SQL Server Import and Export Wizard)

Error 0XC0024107: Data Flow task: An error occurred during task validation.
(SQL Server Import and Export Wizard)

Workaround:

Tick "Enable identity column insertion". (In the Edit mapping option)

How to transfer a native SQL Sever database to a virtual host SQL database