How to migrating all objects in sql server 6.0??

• Eddy Hermanto-285930

  Grasshopper

  Points: 13

  More actions

  February 19, 2006 at 9:13 pm

  #90609

  Hi,

  I usually use ms sql server 2000 DTS to import all objects to a text file. but my client is still using ms sql server 6.0 and i am not used to use it. my questions are  :

  1. Can i migrating all objects from sql server 6.0, plz Help me...

  2. Is bcp( bulk copy program ) can be used in sql server 6.0??

  3. How can i select all objects ???

  once again plz help me...

   

  thx b4

  Deep Dreams

   

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  February 21, 2006 at 10:47 am

  #622383

  1.Yes. But I would perform an upgrade to v7.0, then upgrade to 2000.

  2. Yes.

  3. It's been quite a while since I used v6.0, but I do not believe you can.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."