Re: Import Data succeeds but doesn't copy data?
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Fri, 25 Aug 2006 09:40:25 -0700
If a CONSTRAINT was involved with preventing the data from being imported,
there would be error messages, and you would not receive a "copied xxx rows"
message.
I'm wondering about the location of the resulting table. Are you sure that
you did NOT use the same server for both the source and destination?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"geek-y-guy" <noone@xxxxxxxxxxx> wrote in message
news:OSWC9ovxGHA.4232@xxxxxxxxxxxxxxxxxxxxxxx
I have a dB on a remote SQL2000sp4/win2k server I'm trying to import into
SQL2005x64 (sp1) on Server2003x64. I have a schema that I didn't write that
created the database on both servers.
During config on the import wizard I select to delete existing data and
enable identity insert, and when I run the copy all the steps complete,
including "copied xxx rows", and there are no errors in the report.
But when I check the table, there is no data in it! Would a constraint on
the table prevent the data from actually being inserted, even though it
reports the rows were copied successfully?
.
- Follow-Ups:
- Re: Import Data succeeds but doesn't copy data?
- From: geek-y-guy
- Re: Import Data succeeds but doesn't copy data?
- References:
- Import Data succeeds but doesn't copy data?
- From: geek-y-guy
- Import Data succeeds but doesn't copy data?
- Prev by Date: Re: Partition recommendation in the Database Engine Tuning Advisor
- Next by Date: Customizing maintenance plan reporting in SQL2005
- Previous by thread: Import Data succeeds but doesn't copy data?
- Next by thread: Re: Import Data succeeds but doesn't copy data?
- Index(es):
Relevant Pages
|
Loading
