Godaddy空间如何导入数据到MSSQL Server数据库
Godaddy的Windows系列主机，用户可以将特定文件类型(CSV)的数据导入到您的共享主机的MSSQL Server数据库上。如果您要导入的数据库在别的地方(服务器)上，还想使用这种方法，那么您必须要将您的数据导入成制定类型的文件(CSV类型)。注意: 在导入数据库到您的Windows共享主机之前，你必须先安装(建立)一个SQL Server数据库，同时建立必要的数据库表和字段来存储您的数据。更多相关信息参考：Godaddy主机建立MSSQL数据库方法
下面我们来讲一下具体的导入步骤：
[*]登录后进入您的帐号，Account Manager.[*]在 My Products 区域，选择 Hosting Account List(主机帐号列表).[*]点击Manage Hosting进入主机管理平台.[*]在主机控制中心的 Databases 区块点击 SQL Server 按钮.[*]在你要导入的数据库名称旁边点击 Open Manager 图标.[*]输入你建立数据库时设置的用户名User Name 和密码 Password.[*]在 Navigation导航 面板里，展开 连接（Connection）文件夹.[*]点击“Connect连接”.[*]展开在左侧的 工具Tools 文件夹 并点击 CSV import wizard(CSV导入向导).[*]通过 数据库Database 下拉菜单，选择你要导入的数据库点击 Next Step(下一步).[*]通过 Table(表) 下拉列表，选择你要导入数据的表，点击Next Step(下一步).[*]选择你要导入数据库的列，然后点击Next Step(下一步).[*]选择CSV文件导入并指定文件的类型。[*]最后点击 Submit(提交).另一种导入MSSQL数据库的方法参考：Godaddy主机导入MSSQL数据库教程(总)
相关文章阅读：
Godaddy主机建立MSSQL数据库方法
Godaddy主机如何导出MSSQL数据库
使用ASP/ADO链接Godaddy的MSSQL数据库的代码
Godaddy主机Access数据库的设置方法
本文翻译自官方原文，文档链接：http://help.godaddy.com/article/1393 转载请注明出处(淘主机www.taohost.net翻译)。
Importing Data Into a SQL Server Database
You can import data from a delimited file into your shared hosting account's SQL Server database. If the data you want to import resides in a database elsewhere, you must first export its contents into a delimited file.
NOTE: Prior to importing data into your shared hosting account, you must set up a SQL Server database, along with the necessary tables and fields, to house the data. For more information, see Setting up a SQL Server Database on Your Hosting Account.
To Import Data Into a SQL Server Database
[*]Log in to your Account Manager.[*]In the My Products section, select Hosting Account List.[*]Next to the hosting account you want to modify, click Open.[*]In the Databases section of the Hosting Control Center, click the SQL Server icon.[*]Next to the database to which you are importing, click the Open Manager icon.[*]Enter the User Name and Password you used when setting up the database.[*]In the Navigation panel, expand the Connection folder.[*]Click Connect.[*]Expand the Tools folder on the left and click CSV import wizard.[*]From the Database drop-down menu, choose the database in which to import your data, and then click Next Step.[*]From the Table drop-down list, select the table into which the data will be imported, and then click Next Step.[*]Select the database columns into which the data will be imported, and then click Next Step.[*]Choose the CSV file to import and specify the file's characteristics.[*]Click Submit.
页:
[1]