sql replication monitor

steps. Then restart slave. 6. Synchronous error Handlingfound that MySQL slave server often because of some special characters or symbols generated by the UPDATE statement error, the entire synchronization will be stuck there, the original method is only manually go to the wrong machine to execute the following three SQL statements, skip the error. Mysql>slave stop;Mysql>set GLOBAL sql_slave_skip_counter=1;Mysql>slave start;PS: I have repeatedly enco

Process 1. Set up shared replication directory:\\computer_machine\C$...\.. If the server cancels the default share ($), it fails, a new directory is created, and the directory is given permission to: \\computer_machine\ Share directory Name2. Establish a Windows account for publishing applications3. An error 18483 was encountered while configuring the Distributor because distributor_admin is not defined on this server as a remote login, it is not poss

Tags: style color data ar sp SQL. NET C information1. Requirements: Copy all data from a id= ' 1 ' in the table T_user(1) Premise: There is no primary key in the tableStatement: INSERT INTO T_user select * from T_user where id= ' 1 ' orInsert into T_user (id,name,sex) Select from Id,name,sex from T_user where id= ' 1 'Results: There were two identical data of id= ' 1 ' in the table;(2) Premise: ID is primary keyStatement: (set SqlParameter parameter w

1: When a new table does not exist (that is, copy the data while creating a new table with the same structure as the old table) SELECT * to dbo.tablebackup from Dbo.tablenamewhere ID between 0 and 20 2: The new table already exists, inserting data from the old table. (Note: The primary key does not replicate) INSERT into Dbo.tablebackup (Col1,col2,col3,col4 ...) SELECT Col1,col2,col3,col4 ... From Dbo.tablenamewhere ID between 0 and 20 SQL

--insert into pppcopy SELECT * FROM PPP//Get data from table PPP and insert it into pppcopy, copy only table data, do not copy table structure (prerequisite: Table pppcopy1 exists)--select * into PPPCOPY1 from PPP//copy data from PPP to PPPCOPY1, copy table data and table structure (provided that table pppcopy1 does not exist)--select * into PppCopy2 from PPP where 1=0//copies the table structure of PPP to PPPCOPY2, without copying data (provided that table pppcopy1 does not exist)--create table

= 3 Modifying a configuration file EXECSp_change_agent_parameter@profile_id = -, @parameter_name = 'MaxBCPThreads',@parameter_value = 4 EXECSp_change_agent_parameter@profile_id = -, @parameter_name = 'BcpBatchSize',@parameter_value = 100000 EXECSp_change_agent_parameter@profile_id = -, @parameter_name = 'PollingInterval',@parameter_value = 500000 after optimization Subscription Library Generation The test results show

onA.uid=B.uid--left connection (based on left table, connection right with connection data, not NULL) Select * fromQ_user a Left JoinUserInformation b--inner can be omitted onA.uid=B.uid--Right connection (based on the right table) Select * fromQ_user a Right JoinUserInformation b--inner can be omitted onA.uid=B.uid--self-connect (just connect yourself to a table and take a different alias) Select * fromQ_user a Right JoinQ_user b--inner can be omitted onA.uid=B.uid----------------Union-

Copy the contents of a to a new tableDescriptionWith data table A, you want to export his content to another table B, at which point B is not created and you want to create table B at the same time as the export.SELECT *into B [in Externaldatabase] from ASecond, copy the contents of a to the existing table BDescriptionWith data table A, you want to export his content to another table B, at which point B is created and you want to create table B at the same time as the export.Insert into B (b_col