How to import and export an MSSQL database from Godaddy

Source: Internet
Author: User

How to import a database
You can import SQL Shared Server databases from restricted files. If you want to import data stored elsewhere, copy the content to the restricted file first. (Note: before importing a database, you must first set an SQL Server database and then store the data in the necessary tables and topics)
Steps:
1. log on to Account Manager.
2. Select Hosting Account List in My product options.
3. Select the account you want to modify and click open.
4. In the database options on the control panel, click SQL Server
5. Click Open Manager on the database to be imported.
6. Click Connection on the Navigation panel.
7. Click Connetion in Connection.
8. Set the database and enter the User Name and Password.
9. Click Connect.
10. Open the Tools Folder on the left and click CSV import wizard.
11. from the drop-down menu of the Database, select the Database to be imported, and then select Next Step.
12. from the drop-down menu of the Table, select the platform for data import and click Next Step.
13. Select the database columns for data import and click Next Step.
14. Select a CSV file to import and determine the file category.
15. CLICK: Submit
How to export a database
The database can be exported from the SQL Server database manager to XML or CSV files.
Steps:
1. log on to Account Manager.
2. In hosting & Email, select Hosting Account List
3. Select the account you want to modify and click open.
4. In the Database option on the control panel, click SQL Server on this page to create a new Database or delete or change the original Database.
5. For better management functions, click Open Manger.
6. Click connectiontwice and enter the database user name and password.
7. Select Tables from the drop-down menu of the Database.
8. Open View Contents
9. Open the XML or CSV link and confirm the download as prompted.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.