如何从Godaddy导出DB？ [英] How to export DB from Godaddy?

问题描述

我格式化了我的电脑，忘了从磁盘获取数据库文件并丢失数据库文件。现在我想从我的Godaddy帐户导出数据库文件在本地工作。我要备份，但无法恢复，出现以下错误：

System.Data.SqlClient.SqlError：数据库已备份一个服务器
运行版本10.50.2796。该版本与此
服务器不兼容，该服务器运行版本10.00.1600。在支持备份的服务器上恢复
数据库，或者使用与此服务器兼容的
备份。 （Microsoft.SqlServer.Smo）

如何从godaddy主机获取MS SQL SERVER数据库文件？

$ b $假设您可以从计算机直接访问GoDaddy数据库，您可以使用WebDeploy v3的新DbDacFx提供程序将您的数据库从GoDaddy的服务器发布到您自己的：

msdeploy.exe -verb：sync -source：dbDacFx =您的GoDaddy连接字符串-dest：dbDacFx =您的本地连接字符串

默认情况下，这也会包括GoDaddy数据库中的任何数据。如果您希望排除数据并仅提取模式，只需向源添加，includeData =false即可。

这是一个增量模式同步（对于一个空的目的地，它会做一个副本，但你可以这样做以拉/推增量更改），但对于数据它将总是截断当 includeData =true（这是默认值）时，目标数据库。

I formatted my PC, forgot to take DB files from disk and lose db files. Now I want to export database file from my Godaddy account to work in local. I toke backup, but could not restore it, got so error:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.2796. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

How can I take MS SQL SERVER database file from godaddy hosting?

解决方案

Assuming you have direct access to your GoDaddy database from your computer, you could use WebDeploy v3's new DbDacFx provider to publish your database from GoDaddy's server to your own:

msdeploy.exe -verb:sync -source:dbDacFx="your GoDaddy connection string" -dest:dbDacFx="your local connection string"

By default this will also include any data in your GoDaddy DB. If you wish to exclude data and just fetch the schema, just add ,includeData="false" to the source.

This is an incremental schema sync (for an empty destination, it'll do a copy, but you can do this later to pull/push incremental changes), but for the data it will always truncate the target database when includeData="true" (which is the default).

这篇关于如何从Godaddy导出DB？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！