Help : About SQL Server 2005 Express Edition - DB

Discussion in 'MySQL' started by okpara36, Dec 14, 2007.

0
  1. #1
    I m using SQL Server 2005 Express Edition and I would like to know the steps.. how can I export my database ? because I dont find the option export/import ?
    Is there a tool to convert it to MDB ?


    thank you
     
    okpara36, Dec 14, 2007 IP
  2. mr_wonderful

    mr_wonderful Peon

    Messages:
    128
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    in the Object Explorer pane:

    right click on the database > Tasks > Export Data
     
    mr_wonderful, Dec 14, 2007 IP
  3. okpara36

    okpara36 Peon

    Messages:
    272
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I m using express edition I dont find export data :s
     
    okpara36, Dec 15, 2007 IP
  4. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #4
    Do you have the program "Microsoft SQL Server Management Studio Express"
    installed? It is a free program from Microsoft for management functions.
     
    Kuldeep1952, Dec 15, 2007 IP
  5. okpara36

    okpara36 Peon

    Messages:
    272
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yeah I m using it and I dont find where to export the data or the DTSWIZAR :(
     
    okpara36, Dec 16, 2007 IP
  6. okpara36

    okpara36 Peon

    Messages:
    272
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #6
    bumpbump bump
     
    okpara36, Dec 18, 2007 IP
  7. heyman

    heyman Peon

    Messages:
    70
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    did you right click on the database node in the tree?

    May be try All Tasks -> Export/Import
     
    heyman, Dec 22, 2007 IP
  8. okpara36

    okpara36 Peon

    Messages:
    272
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I dont find export Import I m using EXPRESS EDITION !! I said do you have any idea ?
     
    okpara36, Dec 22, 2007 IP
  9. heyman

    heyman Peon

    Messages:
    70
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #9
    i generally work with the full fledge management studio which comes with SQL server. you may download a demo version of it from MS site or use another front end tool like EMS for SQL
     
    heyman, Dec 22, 2007 IP