Copy Data using Export Wizard in SQL 2005

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?
LVL 1
dba123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LowfatspreadCommented:
have you consisdered using replication either transactional or snapshot...
publishing the table from serverA to serverB
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dba123Author 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.
0
dba123Author 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)
 

0
dba123Author Commented:
I made the UID non-identity an it worked fine now....nevermind.
0
Aneesh RetnakaranDatabase AdministratorCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.