将 SQL Server Management Studio Express 导出到 GoDaddy 时出现问题
我在将 SQL Server Management Studio Express 表导出到 GoDaddy Web 服务器时遇到了麻烦。 GoDaddy 的支持也无济于事。我一开始使用 SQL Server 的 Microsoft 数据库发布向导，认为这会很“容易”......事实并非如此！即使我使用的是为 GoDaddy 站点中的 SQL 数据库创建的用户和密码，我也遇到了用户/密码错误。我打电话给 GoDaddy 的服务台支持人员，并经历了多次流程迭代才使事情正常运转，但没有成功。最后，那个支持人员表现得好像他的手机突然坏了，然后跑开了。
必须有某种方法可以将 SQL Server 上传到网络服务器而不需要太多麻烦。
有什么建议吗？
I'm having a terrible time exporting SQL Server Management Studio Express tables to the Go Daddy webserver. Go Daddy support can't help either. I started by using Microsoft Database Publishing Wizard for SQL Server thinking it would be 'easy'....not! I ran into user/password errors even though I was using the user and password that was created for the SQL database in the Go Daddy site. I called help desk support at Go Daddy and went through several iterations of processes to get the thing working but it didn't. Finally, the support guy acted like his phone went on the blip and scuttled away.
There has got to be someway to upload SQL Server to a webserver without a lot of drama.
Any suggestions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我有类似的问题。事实证明，您必须在数据库发布向导中使用两个路径/用户名/密码。第一个是访问 GoDaddy，第二个是访问数据库。当我输入数据库信息时，我没有意识到有一个不同的服务器地址。一旦这个问题得到解决，我就可以使用数据库发布向导了。
我尝试了备份和恢复，但如果备份是在 GoDaddy 之外创建的，则无法恢复到 GoDaddy 数据库。
I had a similar problem. Turns out there are two paths/usernames/passwords that you have to use in the database publishing wizard. This first one is to access Go Daddy and the 2nd is the access the database. I didn't realize there was a different sever address when I entered the database information. As soon as that was fixed I was able to use the database publishing wizard.
I tried the backup and restore, but you can't restore to the Go Daddy database if the back up was created outside of Go Daddy.
我发现我可以使用 GoDaddy 数据库中的查询分析器上传 SQL 脚本来创建表。那行得通。然而，所有的关系并没有转移。乍一看好像所有字段都转移了。我想，我必须直接在网站上管理关系。不知道为什么他们没有转移。
I figured out that I can use the query analyzer in the Go Daddy database to upload the SQL script to create the tables. That worked. However, all of the relationships did not transfer. It looks like all of the fields transferred upon first glance. I guess, I'll have to manage the relationships directly on the site. Not sure why they didn't transfer.
如果有人在将 SQL Server 数据库上传到 GoDaddy 时遇到问题，请查看 http://jahan1987.blogspot.com/2012/08/godaddy-sql-server-2008-database-upload.html
If anyone have problem with uploading SQL server database to GoDaddy please look at http://jahan1987.blogspot.com/2012/08/godaddy-sql-server-2008-database-upload.html
在两台服务器之间移动 SQL Server 数据库的最简单方法是使用备份和还原方法。
源数据库。
新服务器。
您可能会发现以下 Microsoft SQL Server 论坛主题很有用：
如何使用 SQL Server 2005 Express 备份数据库？
请参阅 SQL Server 文档以使用 T-SQL 执行数据库备份和恢复。
以下是用于执行 SQL Server 数据库还原的 GoDaddy 文档。
The simplest method to move a SQL Server Database between two servers is to use the Backup and Restore method.
source database.
new server.
You may find the following Microsoft SQL Server Forum thread useful:
How do you backup a database using sql server 2005 express?
Consult the SQL Server Documentation for performing a database backup and restore using T-SQL.
Here is the GoDaddy documentation for performing a SQL Server Database restore.