July 3, 2008 at 10:34 am
I have partitioned one of the table and found weird issue. I am trying to copy data from SQL Server 2000 to SQL Server 2005 partitioned table Data exported correctly but when I compare records with target table with desctination table, it does not matched. Following is the partitioned function.
CREATE PARTITION FUNCTION [PFBTCFunction](INT)
AS
RANGE LEFT FOR VALUES
( 10512,10603,10606,10609,10612,
10703,10706,10709,10712,10803,
10806,10809,10812
)
for example
target server sql 2000 destication server 2005
Period recordcount period recordcount
104071008039104071054012
104081164029104081210799
104091240682104091280269
104101209774104101236570
104111175682104111201741
104121178158104121604319
105011054153105011629707
July 3, 2008 at 11:45 am
Try moving it to a staging table on the 2005 server, then moving it to the partitioned table.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply