从一台主机拷贝sql server数据库到另外一台主机 C++实现 给出完整代码

以下是一个使用 SQL Server Backup API 在 C++ 中实现从一台主机拷贝 SQL Server 数据库到另外一台主机的示例代码：

#include <iostream>
#include <windows.h>
#include <sqlapitypes.h>
#include <sqlext.h>
#include <sqltypes.h>
#include <sql.h>

using namespace std;

// 定义源数据库和目标数据库的连接信息
const char* src_server = "localhost";
const char* src_database = "test_db";
const char* src_username = "sa";
const char* src_password = "password";

const char* dest_server = "192.168.1.100";
const char* dest_database = "test_db";
const char* dest_username = "sa";
const char* dest_password = "password";

// 定义备份文件路径
const char* backup_file = "C:\\temp\\test_db.bak";

// 定义连接句柄和语句句柄
SQLHANDLE src_conn_handle = NULL;
SQLHANDLE src_stmt_handle = NULL;
SQLHANDLE dest_conn_handle = NULL;
SQLHANDLE dest_stmt_handle = NULL;

// 定义错误处理函数
void show_error(SQLHANDLE handle, SQLSMALLINT type)
{
    SQLCHAR sqlstate[6], message[256];
    SQLINTEGER native_error;
    SQLSMALLINT message_length;

    SQLGetDiagRec(type, handle, 1, sqlstate, &native_error, message, 256, &message_length);

    cout << "SQL Error " << native_error << " (" << sqlstate << "): " << message << endl;
}

int main()
{
    // 连接源数据库
    SQLRETURN retcode;
    retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &src_conn_handle);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(src_conn_handle, SQL_HANDLE_ENV);
        return -1;
    }

    retcode = SQLSetEnvAttr(src_conn_handle, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(src_conn_handle, SQL_HANDLE_ENV);
        return -1;
    }

    retcode = SQLAllocHandle(SQL_HANDLE_DBC, src_conn_handle, &src_conn_handle);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(src_conn_handle, SQL_HANDLE_ENV);
        return -1;
    }

    retcode = SQLConnect(src_conn_handle, (SQLCHAR*)src_server, SQL_NTS, (SQLCHAR*)src_username, SQL_NTS, (SQLCHAR*)src_password, SQL_NTS);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(src_conn_handle, SQL_HANDLE_DBC);
        return -1;
    }

    // 备份源数据库
    retcode = SQLAllocHandle(SQL_HANDLE_STMT, src_conn_handle, &src_stmt_handle);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(src_stmt_handle, SQL_HANDLE_STMT);
        return -1;
    }

    SQLCHAR backup_command[256];
    SQLINTEGER backup_command_length;
    backup_command_length = sprintf((char*)backup_command, "BACKUP DATABASE %s TO DISK = '%s'", src_database, backup_file);

    retcode = SQLExecDirect(src_stmt_handle, backup_command, backup_command_length);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(src_stmt_handle, SQL_HANDLE_STMT);
        return -1;
    }

    // 连接目标数据库
    retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &dest_conn_handle);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(dest_conn_handle, SQL_HANDLE_ENV);
        return -1;
    }

    retcode = SQLSetEnvAttr(dest_conn_handle, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(dest_conn_handle, SQL_HANDLE_ENV);
        return -1;
    }

    retcode = SQLAllocHandle(SQL_HANDLE_DBC, dest_conn_handle, &dest_conn_handle);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(dest_conn_handle, SQL_HANDLE_ENV);
        return -1;
    }

    retcode = SQLConnect(dest_conn_handle, (SQLCHAR*)dest_server, SQL_NTS, (SQLCHAR*)dest_username, SQL_NTS, (SQLCHAR*)dest_password, SQL_NTS);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(dest_conn_handle, SQL_HANDLE_DBC);
        return -1;
    }

    // 恢复目标数据库
    retcode = SQLAllocHandle(SQL_HANDLE_STMT, dest_conn_handle, &dest_stmt_handle);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(dest_stmt_handle, SQL_HANDLE_STMT);
        return -1;
    }

    SQLCHAR restore_command[256];
    SQLINTEGER restore_command_length;
    restore_command_length = sprintf((char*)restore_command, "RESTORE DATABASE %s FROM DISK = '%s'", dest_database, backup_file);

    retcode = SQLExecDirect(dest_stmt_handle, restore_command, restore_command_length);
    if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
    {
        show_error(dest_stmt_handle, SQL_HANDLE_STMT);
        return -1;
    }

    // 释放连接句柄和语句句柄
    SQLFreeHandle(SQL_HANDLE_STMT, src_stmt_handle);
    SQLDisconnect(src_conn_handle);
    SQLFreeHandle(SQL_HANDLE_DBC, src_conn_handle);
    SQLFreeHandle(SQL_HANDLE_ENV, src_conn_handle);

    SQLFreeHandle(SQL_HANDLE_STMT, dest_stmt_handle);
    SQLDisconnect(dest_conn_handle);
    SQLFreeHandle(SQL_HANDLE_DBC, dest_conn_handle);
    SQLFreeHandle(SQL_HANDLE_ENV, dest_conn_handle);

    return 0;
}

请注意，这只是一个示例代码，您需要根据自己的需要进行修改和调整。此外，您需要确保已正确安装和配置 SQL Server Backup API，并且您具有足够的权限来备份和还原数据库。