datamerge

• vblllove

  Ten Centuries

  Points: 1273

  More actions

  September 22, 2008 at 5:26 am

  #126513

  I have the old database and the New Database. I want to get the Old data to the New one , and I don want to lose the old Id. For Example

  in my old Database I have the BookingID start at 1000

  In the New one I have New BookingId

  How I can merge the data but Keeping the New inserted Bookings with their own Booking ID

  Any other Suggestion is welcome

  best regards

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  September 22, 2008 at 5:44 am

  #874896

  use the import/export wizard and make sure you have the "enable identity insert" option selected