1 Replies - 721 Views - Last Post: 18 April 2012 - 05:03 PM

#1 mindiapolis  Icon User is offline

  • D.I.C Head

Reputation: -4
  • View blog
  • Posts: 175
  • Joined: 31-October 11

transfer table structure

Posted 18 April 2012 - 02:05 PM

Are there any good tutorials on how to transfer specific columns from one table to another?
Is This A Good Question/Topic? 0
  • +

Replies To: transfer table structure

#2 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 782
  • View blog
  • Posts: 1,663
  • Joined: 30-January 09

Re: transfer table structure

Posted 18 April 2012 - 05:03 PM

I'm not sure if there would be tutorials on this, since every case would be different. There are principles on how to do it.

I would, for instance:
  • Create the columns on the target table
  • Develop a query that translates from the source and populates the target
  • Run the query and ensure there are no errors
  • Validate the data, possibly using a query to compare the two tables

Was This Post Helpful? 2
  • +
  • -

Page 1 of 1