jung1975
asked on
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)..
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)..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ?