迁移SQL SERVER 数据库实例
由于某些原因,需要将2个数据库实例合并为1个,也就是说要把其中的一台迁移到另外一台上面。 背景介绍 :下面的B,C代表2个实例,要把B中相关东西迁移到C实例上面。其中B上面有一部分的同步是从另外一台服务器同步过来,这里说是A吧,迁移版本相同(我操作的
由于某些原因,需要将2个数据库实例合并为1个,也就是说要把其中的一台迁移到另外一台上面。
背景介绍 :下面的B,C代表2个实例,要把B中相关东西迁移到C实例上面。其中B上面有一部分的同步是从另外一台服务器同步过来,这里说是A吧,迁移版本相同(我操作的版本为SQL SERVER 2008R2)
简单步骤如下:
1. 复制A实例上面的 Login和 Job 到B上面
Login的迁移可以参考:http://support.microsoft.com/kb/918992
Job的迁移可以使用资源管理器进行批量的生成,可以参见: http://www.cnblogs.com/dudu/archive/2013/02/27/sql-server-export-job.html
如果是新的环境可以采用还有msdb的方法来建立Job
2. 把B中有从A同步过来的表查询出来,然后建立A->C对应的同步连路
3. 检查B中服务器用户对应有权限是否在C中都已经存在
4. 停掉B中的应用程序,保证没有进程 (涉及非DBA人员)
然后进行备份,停掉服务(或者把库设置为离线) , 在C中还原
在完成步骤 1-3 的工作之后, 需要与非DBA人呗确认切换的时间, 有什么问题需要及时联系
5. 需要把A->B的复制连路断掉,删除就OK了。
其中第4步也可以用镜像或者是复制
镜像: 可以对数据库进行数据库镜像配置,停了业务,切换到镜像服务器。
复制: 对数据库的表都建立复制,完成之后,等待连接串切换到订阅端,然后进行停机操作。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).

1. Open the WeChat app on the old device, click [Me] in the lower right corner, select the [Settings] function, and click [Chat]. 2. Select [Chat History Migration and Backup], click [Migrate], and select the platform to which you want to migrate the device. 3. Click [Select chats to be migrated], click [Select all] in the lower left corner, or select chat records yourself. 4. After selecting, click [Start] in the lower right corner to log in to this WeChat account using the new device. 5. Then scan the QR code to start migrating chat records. Users only need to wait for the migration to complete.

Go language is an efficient, concise and easy-to-learn programming language. It is favored by developers because of its advantages in concurrent programming and network programming. In actual development, database operations are an indispensable part. This article will introduce how to use Go language to implement database addition, deletion, modification and query operations. In Go language, we usually use third-party libraries to operate databases, such as commonly used sql packages, gorm, etc. Here we take the sql package as an example to introduce how to implement the addition, deletion, modification and query operations of the database. Assume we are using a MySQL database.

1. On the old device, click "Me" → "Settings" → "Chat" → "Chat History Migration and Backup" → "Migrate". 2. Select the target platform device to be migrated, select the chat records to be migrated, and click "Start". 3. Log in with the same WeChat account on the new device and scan the QR code to start chat record migration.

By opening WeChat on the old device, selecting "Chat History Migration and Backup" and following the prompts, users can migrate their chat history to the new device. The migration process involves selecting the chats that need to be migrated, scanning the QR code and waiting for the migration to complete.

The best way to move legacy C++ applications to the cloud: Re-platform: Move the application code to a cloud-native platform (such as Kubernetes) and leverage cloud services. Cloudization: Deploy applications on cloud platforms and utilize cloud services without code refactoring.

How to use MySQLi to establish a database connection in PHP: Include MySQLi extension (require_once) Create connection function (functionconnect_to_db) Call connection function ($conn=connect_to_db()) Execute query ($result=$conn->query()) Close connection ( $conn->close())

Hibernate polymorphic mapping can map inherited classes to the database and provides the following mapping types: joined-subclass: Create a separate table for the subclass, including all columns of the parent class. table-per-class: Create a separate table for subclasses, containing only subclass-specific columns. union-subclass: similar to joined-subclass, but the parent class table unions all subclass columns.
