Replicate Data Changes

1. On the EC2 instance you RDP-ed into, use Oracle SQL Developer connect to the source Oracle RDS.

2. Open a New Query window and execute the following statement to insert 5 new sports into the sport_type table:

   INSERT ALL
   
   INTO dms_sample.sport_type (name,description) VALUES ('hockey', 'A sport in which two teams play against each other by trying to more a puck into the opponents goal using a hockey stick')
   
   INTO dms_sample.sport_type (name,description) VALUES ('basketball', 'A sport in which two teams of five players each that oppose one another shoot a basketball through the defenders hoop')
   
   INTO dms_sample.sport_type (name,description) VALUES ('soccer','A sport played with a spherical ball between two teams of eleven players')
   
   INTO dms_sample.sport_type (name,description) VALUES ('volleyball','two teams of six players are separated by a net and each team tries to score by grounding a ball on the others court')
   
   INTO dms_sample.sport_type (name,description) VALUES ('cricket','A bat-and-ball game between two teams of eleven players on a field with a wicket at each end')
   
   SELECT * FROM dual; 
   
   COMMIT;
   
   SELECT * FROM dms_sample.sport_type; 
   

For SQL Server Source:

1. Use Microsoft SQL Server Management Studio to connect to the Source SQL Server on the EC2 instance.

2. Open a New Query window and execute the following statement to insert 5 new sports into the sport_type table:

   USE [dms_sample]
   GO
   
   INSERT INTO [dbo].[sport_type]
           ([name]
           ,[description])
       VALUES
           ('hockey', 'A sport in which two teams play against each other by trying to more a puck into the opponents goal using a hockey stick');
   
   INSERT INTO [dbo].[sport_type]
           ([name]
           ,[description])
       VALUES
           ('basketball', 'A sport in which two teams of five players each that oppose one another shoot a basketball through the defenders hoop');
   
   INSERT INTO [dbo].[sport_type]
           ([name]
           ,[description])
       VALUES
           ('soccer','A sport played with a spherical ball between two teams of eleven players');
   
   INSERT INTO [dbo].[sport_type]
           ([name]
           ,[description])
       VALUES
               ('volleyball','two teams of six players are separated by a net and each team tries to score by grounding a ball on the others court');
   
   INSERT INTO [dbo].[sport_type]
           ([name]
           ,[description])
       VALUES
           ('cricket','A bat-and-ball game between two teams of eleven players on a field with a wicket at each end');
   
   GO