Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Aug 2005
    Posts
    365
    Thanks
    7
    Thanked 1 Time in 1 Post

    Question How to export MS SQL DB (like we export mySQL DB from PHPMyAdmin)

    Somebody plz guide me how can I export DB from MS SQL SERVER? I know how to export MySQL DB using PHPMyAdmin or SQL Yog. Plz guide me this for MS SQL SERVER too.

    Regards

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    use the import and export wizard?
    I am the luckiest man in the world

  • #3
    Regular Coder
    Join Date
    Aug 2005
    Posts
    365
    Thanks
    7
    Thanked 1 Time in 1 Post
    Okie, but would you please guide me where I can find that WIZARD? I am new to SQL SERVER & couldn't find any Import/Export wizard

  • #4
    Senior Coder
    Join Date
    Dec 2002
    Location
    Arlington, Texas USA
    Posts
    1,065
    Thanks
    4
    Thanked 8 Times in 8 Posts
    In Enterprise Manager in the Console Root you can click on Tools then select Data Transformation Services and then select whether you are going to import or export data.

    Another way to do this in Enterprise Manager there is a row of icons at the top of the Console Root. Look for the Wizard's Wand and then select Data Transformation Services and then select whether you are going to import or export data.

    Another way to do this is to select the database in the left pane of the Console Root (you can also do this by pointing to tables if you have expanded the database) then right mouse click, this will bring up a list with one of the options being All Tasks, from here you can click Import Data or Export Data. This will open the DTS wizard.


    One more way to move data is in the left pane of the Console Root you will find a folder called Data Transformation Services, expand that folder and click on Local Packages. Then in the right pane right mouse click and select New Package, this doesn't use the wizard here so you have to select each item from the list of icons. I don't recommend this one if you are a beginner to SQL Server.


    Now if you want to make a copy of the database only but not copy the data you can also make a Script of the database. This can include all users, roles, SQL Server logins, object level permissions, Triggers, Indexes, constraints like Primary & Foreign keys as well as SPROCs and UDFs. This is done in Enterprise Manager by selecting the database in the left pane of the Console Root, right mouse click on that database then select All Tasks and from here select Generate SQL Script, click that then in the window that just opened click the button labeled Show All, then check the box for Script all objects, Then click Options and select the options you want, then finally click OK and you will have a script generated which can then be used to build a copy of the database (sans data).


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •