Home Database Mysql Tutorial 迁移SQL SERVER 数据库实例

迁移SQL SERVER 数据库实例

Jun 07, 2016 pm 03:00 PM
server sql reason Example database migrate

由于某些原因,需要将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步也可以用镜像或者是复制

镜像: 可以对数据库进行数据库镜像配置,停了业务,切换到镜像服务器。

复制: 对数据库的表都建立复制,完成之后,等待连接串切换到订阅端,然后进行停机操作。

 

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos Jul 18, 2024 am 05:48 AM

Apple's latest releases of iOS18, iPadOS18 and macOS Sequoia systems have added an important feature to the Photos application, designed to help users easily recover photos and videos lost or damaged due to various reasons. The new feature introduces an album called "Recovered" in the Tools section of the Photos app that will automatically appear when a user has pictures or videos on their device that are not part of their photo library. The emergence of the "Recovered" album provides a solution for photos and videos lost due to database corruption, the camera application not saving to the photo library correctly, or a third-party application managing the photo library. Users only need a few simple steps

How to transfer WeChat chat history to another mobile phone How to transfer WeChat chat history to another mobile phone May 08, 2024 am 11:20 AM

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.

Cloud Modernization with C++: Migrating Legacy Applications to the Cloud Cloud Modernization with C++: Migrating Legacy Applications to the Cloud Jun 01, 2024 am 09:21 AM

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.

Detailed tutorial on establishing a database connection using MySQLi in PHP Detailed tutorial on establishing a database connection using MySQLi in PHP Jun 04, 2024 pm 01:42 PM

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())

How to handle database connection errors in PHP How to handle database connection errors in PHP Jun 05, 2024 pm 02:16 PM

To handle database connection errors in PHP, you can use the following steps: Use mysqli_connect_errno() to obtain the error code. Use mysqli_connect_error() to get the error message. By capturing and logging these error messages, database connection issues can be easily identified and resolved, ensuring the smooth running of your application.

How to use database callback functions in Golang? How to use database callback functions in Golang? Jun 03, 2024 pm 02:20 PM

Using the database callback function in Golang can achieve: executing custom code after the specified database operation is completed. Add custom behavior through separate functions without writing additional code. Callback functions are available for insert, update, delete, and query operations. You must use the sql.Exec, sql.QueryRow, or sql.Query function to use the callback function.

How to connect to remote database using Golang? How to connect to remote database using Golang? Jun 01, 2024 pm 08:31 PM

Through the Go standard library database/sql package, you can connect to remote databases such as MySQL, PostgreSQL or SQLite: create a connection string containing database connection information. Use the sql.Open() function to open a database connection. Perform database operations such as SQL queries and insert operations. Use defer to close the database connection to release resources.

How to handle database connections and operations using C++? How to handle database connections and operations using C++? Jun 01, 2024 pm 07:24 PM

Use the DataAccessObjects (DAO) library in C++ to connect and operate the database, including establishing database connections, executing SQL queries, inserting new records and updating existing records. The specific steps are: 1. Include necessary library statements; 2. Open the database file; 3. Create a Recordset object to execute SQL queries or manipulate data; 4. Traverse the results or update records according to specific needs.

See all articles