partition

I am trying to do partition switch.. the destination table has an identity column ,
How can I handle partition switch in and out if the destination table has an identify column? I need to be able to insert the unique id into the destination table ( there shouldn’t be no duplicate id in the destination table)..
jung1975Asked:
Who is Participating?
 
TheTullCommented:
Is this just an issue of not being able to insert the unique ID into the table after you get your records, in which case you can use set identity_insert table on to enable inserting into the identity column of that table? Or are you running into something more complicated?
0
 
jung1975Author Commented:
I guess my question is
Do i have to have an idenity field in the source table if the destination table has the identity field in order to switch in or out? i know the structure of two tables should be the same if you want to do the partition switch.. does it include an indentity field?

if so, the identity in source table ( table you are trying to switch in ) need to to have an identy value greater than the max value of identity in the destination table.. how can I handle the identiy column in partition switch situation ?
0
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.

All Courses

From novice to tech pro — start learning today.