We help IT Professionals succeed at work.

Copy Data using Export Wizard in SQL 2005

dba123
dba123 asked
on
Medium Priority
971 Views
Last Modified: 2012-05-05
I'm trying to refresh a copy of a table on serverB with the same table on serverA.  I tried using the export wizard but it errors out. I deleted the table on ServerB now.   How can I get the entire table and its contents recreated on ServerB from ServerA?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2011
Commented:
have you consisdered using replication either transactional or snapshot...
publishing the table from serverA to serverB

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I'm working on replication, testing it and getting rid of the errors.  For now, I just need to get the table over quickly.

Author

Commented:
when I try the wizard, I get the following errors on the copy:

- Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "UID".
 (SQL Server Import and Export Wizard)
 
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
 (SQL Server Import and Export Wizard)
 
Error 0xc004706b: Data Flow Task: "component "Destination - payhistory" (232)" failed validation and returned validation status "VS_ISBROKEN".
 (SQL Server Import and Export Wizard)
 
Error 0xc004700c: Data Flow Task: One or more component failed validation.
 (SQL Server Import and Export Wizard)
 
Error 0xc0024107: Data Flow Task: There were errors during task validation.
 (SQL Server Import and Export Wizard)
 

Author

Commented:
I made the UID non-identity an it worked fine now....nevermind.
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
Hi dba123,
 You can create a table with the same structure on server2  and run the query


insert into server2.dbo.table1
select * from server1.dbo.table1
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.