golden gate replication from oracle to sql server

Test environment: Host: Database SQL SERVER08 r2 system Windows Server R2 IP192.168.1.202Cong: Database SQL Server12 system Windows IP192.168.1.100Implementation steps: 1, first on the master-slave machine to add user sqladmin, Password * * * *, and set up under the Administeator (host for example)2. Turn off the master and the firewall3, set the startup type of

Label:In today's scale OLTP system, it is a good way to solve the problem by replicating multiple copies in order to alleviate the single point of reading and writing pressure in the database, especially the read pressure.The SQL Server transactional replication transactional Replication is the most common form of

configuration file (executed at the Distributor on any database) exec sp_add_agent_parameter @profile_id = one --the ID of the profile , @parameter_name = ' resolverstate ' --parameter name , @parameter_value = 1 --parameter value Change the parameters of the agent configuration file (executed at the Distributor on any database) exec sp_change_agent_parameter @profile_id = one --The ID of the configuration file , @parameter_name = ' resolverstate ' -- Parameter name , @paramete

Reposted from: longtang Bay 1.1.1 obtain the first N records SQL Server: Select Top N * From xtable ORACLE: Select * From xtable where rownum DB2: Select * From xtable fetch first n rows only 1.1.2 obtain the current date SQL Server: Select getdate ()

Label: http://blog.csdn.net/weiwenhp/article/details/8094739 Directory (?) [-] SQL Server Rights Management The difference between login and user Role roles granting permissions Compare Oracle vs. SQL Server with a metaphor Ora

But I think this feature is also useful for setting up a backup server or a test server. On a single machine to publish services, you can subscribe to other machines in the SQL, according to your release of different conditions, you can make a timed synchronization, real-time synchronization, synchronization and other different publications and subscriptions. T

For this question, the initial assumption is simpler: replace the keyword and function names that are not the same in the SQL statement, such as To_date in Oracle to convert SQL Server. can be executed on SQL Server. This can be t

Tags: tin pre ATI Subscription. NET stat Func PSU startOriginal: SQL Server transactional replication uses scripts to add publications for an object--use [Publish library]--Add Table: Create the project and add it to the publication exec sp_addarticle @publication = n ' replicationname ', @article = N ' MyObject ', @sourc E_owner = n ' dbo ', @source_object = N '

, Ignore_dup_key = off, Allow_row_locks = on, allow_page_locks = ON) O N [PRIMARY]) on [PRIMARY]GOThen: Insert into Table1 (filed1,filed2) Select Filed1,filed2 from Table2 (this is definitely not a correct notation, self-increment ID problem)thus: SET IDENTITY_INSERT [Table_1] on INSERT to Table1 (id,filed1,filed2) Select Id,filed1,filed2 from Table1 SET IDENTITY _insert [Table_1] Off (SET identity_insert [table_1] on | | OFF allows an explicit value to be inserted into the identity column of th

This article takes SQL Server 2k as an example to illustrate the specific implementation process for SQL Server to Oracle connection server. 　 1. Requires the Oralce client software and sqlserver2000 software to be installed on

Create an Oracle Link Server in 64-bit SQL Server Sometimes we want to access data from another SQL Server database or data from other Oracle databases under one

Oracle is not installed, and pl/SQL is directly used to connect to oracle server in 3 minutes. Many people, especially those who do not like oracle, must learn from oracle and think that oracl