MMSQ Server 2008 how to export to .sql

Results 1 to 8 of 8
  1. #1
    Elite Member Matrixo is offline
    Member +Rank
    Aug 2008 Join Date
    181Posts

    MMSQ Server 2008 how to export to .sql

    Hello,
    I have crazy problem, because I don`t know how to export DataBaste to .sql file, anyone can tell me how? :>
    When I trying "generate script" id doing only procedures :>



    @Edit:
    Aw... wrong section, I am so sorry.
    Last edited by Matrixo; 19-10-09 at 05:20 PM.


  2. #2
    Member Grimmycakes is offline
    MemberRank
    Aug 2009 Join Date
    Under your bedLocation
    87Posts

    Re: MMSQ Server 2008 how to export to .sql

    If I understand correctly, go to your database, right click on it, tasks and backup. This is for 2005. But I think it should basically be the name.

  3. #3
    Elite Member Matrixo is offline
    Member +Rank
    Aug 2008 Join Date
    181Posts

    Re: MMSQ Server 2008 how to export to .sql

    No.. i don`t want make backup.
    I wish make a file with DataBase procedures, tables and entires, like ACCOUNT_DBF.sql file or ITEM_01_DBF.sql file

  4. #4
    Grand Master GlaphanKing is offline
    Grand MasterRank
    Sep 2008 Join Date
    World of MorrowLocation
    2,593Posts

    Re: MMSQ Server 2008 how to export to .sql

    Use the Management Studio.

  5. #5
    Elite Member Matrixo is offline
    Member +Rank
    Aug 2008 Join Date
    181Posts

    Re: MMSQ Server 2008 how to export to .sql

    Quote Originally Posted by GlaphanKing View Post
    Use the Management Studio.
    I know, but I can`t find find option to do it, Could you tell me where Can i find it?

    Btw GlaphanKing, I said 1 day ago that I apologise for wrote topic in wrong section so I don`t know why did yo gave me warning :(

  6. #6
    Grand Master BBim is offline
    Grand MasterRank
    Sep 2008 Join Date
    127.0.0.1Location
    1,110Posts

    Re: MMSQ Server 2008 how to export to .sql

    Almost what grimster101 said, but instead of backup you click generate sql script.

    You can just google: mssql export db structure
    and you will find answers.

  7. #7
    Elite Member Matrixo is offline
    Member +Rank
    Aug 2008 Join Date
    181Posts

    Re: MMSQ Server 2008 how to export to .sql

    Quote Originally Posted by BBim View Post
    Almost what grimster101 said, but instead of backup you click generate sql script.

    You can just google: mssql export db structure
    and you will find answers.
    Omg... but when I use generate script Id don`ing only procedures, not tables and entires ;/

  8. #8
    Grand Master BBim is offline
    Grand MasterRank
    Sep 2008 Join Date
    127.0.0.1Location
    1,110Posts

    Re: MMSQ Server 2008 how to export to .sql

    Quote Originally Posted by Matrixo View Post
    Omg... but when I use generate script Id don`ing only procedures, not tables and entires ;/
    "You can just google: mssql export db structure
    and you will find answers."
    You probably configured export script wrong because I used it to export database structure on a project I had to do for school and it worked fine.



Advertisement