How to copy data from multiple table from one DB to other DB in sql server where Timestamp is used.

srinivas_dynamicssrinivas_dynamics HyderabadMember Posts: 41
I need to copy a set of tables from one DB to another DB, the tables structure is the same but the problem is when using Import/Export wizard I'm getting error that for table.

Timestamp is used as column for all the set of tables which we cannot use for copy, so some one please suggest how to copy the data from db to db.

Error:

Validating (Error) Messages Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "timestamp". (SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task 1: Column metadata validation failed. (SQL Server Import and Export Wizard)

Error 0xc004706b: Data Flow Task 1: "Destination - Currency" failed validation and returned validation status "VS_ISBROKEN". (SQL Server Import and Export Wizard)

Error 0xc004700c: Data Flow Task 1: One or more component failed validation. (SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task 1: There were errors during task validation. (SQL Server Import and Export Wizard)

Thanks,
Srinivas
Thanks in advance,
Srinivas.
Sign In or Register to comment.