Copy entire table and it data

  • What is the fastest way to querry an entire table and its data from one database and create a new table with all of the copyed tables data into another database?

    Erik...

    Can that be done with little effort in the analyzer?

    Dam again!

  • use the dts transfer objects wizard, or the import option (right click, db).

  • Thanks!

    I don't know why i have such a problem working with the data...

    Dam again!

  • WOW!

    Thanks alot on this one.

    That was really smooth,

     

    Thank you!

    Erik...

    Dam again!

  • HTH.

  • Hey Remi  ....  using a separate post for "HTH" is cheating !!!     🙂    That shouldn't count towards your total !

  • Hey what does HTH! mean?

     

    Dam again!

  • HTH = Happy to help. (can also mean Hope this helps)

    I can't post it untill I'm sure the thread is closed...

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply