[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Copy Data using Export Wizard in SQL 2005

Posted on 2006-04-05
Medium Priority
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?
Question by:dba123
  • 3
LVL 50

Accepted Solution

Lowfatspread earned 2000 total points
ID: 16382849
have you consisdered using replication either transactional or snapshot...
publishing the table from serverA to serverB

Author Comment

ID: 16383082
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 Comment

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

- Validating (Error)
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 Comment

ID: 16383122
I made the UID non-identity an it worked fine now....nevermind.
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16383135
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question