Data operations between different server databases
--Create a linked server
exec sp_addlinkedserver ' itsv ', ', ' SQLOLEDB ', ' Remote server name or IP address '
exec sp_addlinkedsrvlogin ' itsv ', ' false ', NULL, ' username ', ' password '
--query Example
SELECT * from ITSV. Database name. dbo. Table name
--Import sample
SELECT * into table from ITSV. Database name. dbo. Table name
--Delete a li
Migrating user mailboxes using the local Move Request toolScene:1) e-mail cross-version upgrade;2) database optimization, migration of high-load users to low-load users;3) Database space collation and release;4) The user in the problem database is migrated to the new library;Benefits:You can avoid downtime by migrating;Select recipients, and then select the Migration tab, select Move to another database.Select the user you want to move.If you move more users at a time, you can also export users
When SQL doesn't meet your needs or SQL is not a must or the best choice, it's time to consider this kind of nosql.When your memory is larger than your data, the schema is not too sure, MongoDB here quietly waiting for my SQL job to see the busy, do not change the design mode, cool in front of pain in the back;When you are the only pursuit of speed, but also to memcached too simple discord, just memory is more than the data, Redis Qiao sang and stood there;Big, big, too big, I said the data, our
(Sr_id,tr_id,dt_money)All methods are encapsulated in a class, the Transfor method is also a transaction operation, the front also said __name__ this built-in property, if the program is directly run __name__ is equal to __main, then if __name__== ' __main__ ' is set up, that is to say, the entrance to the program.3: See below the third way of modularity #-*-coding:utf-8-*-"""Created on Tue June 6 11:45:42 2017@author:a"""ImportSYSImportPymysqlImporttemp2sr_id=sys.argv[1]tr_id=sys.argv[2]dt_mon
Tags: des style blog io color OS SP data on connectionStrings> Addname= "Oadbconnectionstring"connectionString= "Data source=hong-pc\sql2005;initial catalog=oadb; User Id=sa; password=123456 "ProviderName= "System.Data.SqlClient" /> Addname= "Sqlserverconnectionstring"connectionString= "Data source=127.0.0.1\sqlserver2008r2;initial catalog=website;integrated security=false; User Id=sa; password=yk.888888; Connect timeout=15; Encrypt=false; Trustservercertificate=false "ProviderName= "
not possible, error/*The OLE DB provider "MSDASQL" of the linked server "Mysqltest" returned the message "The key column information is insufficient or incorrect." The update affects multiple lines. "。Msg 7345, Level 16, State 1, line 1thThe OLE DB provider "MSDASQL" of the linked server "Mysqltest" cannot delete data from the table "select * from T1 where hour > 2". The update operation does not meet the schema requirements.*/--query operation on the T1 tableSELECT * FROM OPENQUERY (mysqltest,
'; ' Password ', database name. dbo. Table name) as a inner join local table BOn A.column1=b.column1--openquery usage requires creating a connection--First create a connection to create a linked serverexec sp_addlinkedserver ' itsv ', ' ', ' SQLOLEDB ', ' Remote server name or IP address '--QuerySELECT *From OPENQUERY (ITSV, ' SELECT * from database. dbo. Table name ')--Import local tables to remote tablesInsert OpenQuery (ITSV, ' SELECT * from database. dbo. Table name ')SELECT * FROM local su
database. dbo. Table name') asInner join local table B on a. Column A = B. Column
-- 3. opendatasource/openrowsetSELECT *FROM opendatasource ('sqlodb', 'Data Source = ip/ServerName; User ID = login name; Password = password'). test. dbo. roy_ta-- Import a local table to a remote table
Version 2
-- Data operations between databases on different servers--*************************************** **********
Problems with attaching a databaseAccording to the prompts, the data files and logs to be appended belong to different databases.
Back up your data files and try to solve the problem by following the steps below:
1. Create a database with the same name
2. Stop SQL server again (do not detach the database)
3. overwrite the new database with the data file to be appended
4. Restart SQL Server.
5. When yo
Connect two different databases on one page to operate ... I don't know, is it feasible? Is that possible? Of course
MssqlConnStr = "Driver={sql server};server=192.168.1.110;database=news;uid=sa;pwd=123456"Set conn = Server.CreateObject ("ADODB. Connection ")Conn. Open ConnStrMysqlSet myconn = Server.CreateObject ("Adodb.connection")connstrmy= "Driver={mysql ODBC 3.51 Driver};server=localhost;database=uchom
The Tablespace feature-the ability to replicate data files directly between Oracle instances without unloading and loading data-was introduced in Oracle 8i and has since become a feature. Initially, the tablespace and destination databases to be transferred must have the same size module. Support for the increased number of module sizes in Oracle 9i overcomes this limitation. Now, in Oracle 10g, the limitations of the platform have also been largely r
Tags: data res postgre using server ant value Sage selThe following is the installation, configuration, use of FDW to achieve Postgres database mutual access method, reproduced annotated Source:1, source installation FDW support (requires database source installation)Cd/usr/local/postgresql-9.3.2/contrib/postgres_fdwMakeSuMake install2. Create FDW extension (log in to Super User database)\c Postgres PostgresCreate extension POSTGRES_FDW;3, Authorization (the use of the module to grant user test)
This article original website: http://blog.csdn.net/htl258/article/details/5695391------------------------------------------------------------------------------------author:htl258 (Tony)--Date: 2010-06-25 22:23:18--version:microsoft SQL Server (RTM)-10.0.1600.22 (Intel X86)--Jul 9 2008 14:43:34- -Copyright (c) 1988-2008 Microsoft corporation--Developer Edition on Windows NT 5.1 Data manipulation between different SQL Server
', ' SQL Server name '; ' User name '; ' Password ', database name. dbo. Table name) as a inner join local table BOn A.column1=b.column1--openquery usage requires creating a connection--First create a connection to create a linked serverexec sp_addlinkedserver ' zhaowenzhong ', ' ', ' SQLOLEDB ', ' Remote server name or IP address '--QuerySELECT *From OPENQUERY (Zhaowenzhong, ' SELECT * from database. dbo. Table name ')--Import local tables to remote tablesInsert OpenQuery (Zhaowenzhong, ' SELE
1. Modify the Pom.xml fileOpen the Framework/pom.xml file and comment out the unwanted database dependency package, for example, using MySQL, comment out the dependencies of DB2, Oracle, MSSQL2. Modify the \framework\src\main\resources\application.properties file to properly configure the database connection, for example:3. Modify the \framework\src\main\resources\applicationcontext.xml file to properly configure the DataSourceWood elder brother's articles are based on their own practice, you ca
-ignore-db = mysqlReplicate-do-db = testReplicate-ignore-db = mysqlLog-slave-updatesSlave-skip-errors = allSync_binlog = 1 user = mysqlLog-bin = mysql-binServer-id = 2Binlog-do-db = testBinlog-ignore-db = mysqlReplicate-do-db = testReplicate-ignore-db = mysqlLog-slave-updatesSlave-skip-errors = allSync_binlog = 1
The server-id must be unique.Binlog-do-db and replicate-do-db indicate the databases to be synchronized.Binlog-ignore-db and replicate-ignor
Reason:The personal plan points Data Source of the knowledge base is 157 databases. However, based on Bi and other systems, a separate personal plan points of the knowledge base are copied on the 34, so each 157 change occurs, it is troublesome to manually change 34 databases.
Therefore, a trigger was written in 157 to synchronously update the personal plan points of 34
Connect different database authors and sources through MAVEN configuration test environment and development environment: Tong Lingbao Jade-Blog Park collection to →_→: This article from:Macaidong BlogURL: http://www.makaidong.com Summary: Connect different databases with MAVEN configuration test environment and development environment"Connect
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.