Copy data tables on sqlserver2008 to Oracle database via subscription publication

1. Installation of sqlserver2008 R2 products

2. Log in with SA user

3. Click New Release:

650) this.width=650; "title=" clip_image001 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image001 "src=" http://s3.51cto.com/wyfs02/M02/6C/1D/ Wkiol1vagughizjiaab7dhtmscw393.jpg "" 244 "height=" 193 "/>

4. Direct Next Step:

650) this.width=650; "title=" clip_image003 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image003 "src=" http://s3.51cto.com/wyfs02/M00/6C/21/ Wkiom1vaf9qihnvhaabir2k-h_e494.jpg "" 244 "height=" 197 "/>

5. Select the database to publish:

650) this.width=650; "title=" clip_image005 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image005 "src=" http://s3.51cto.com/wyfs02/M01/6C/1D/ Wkiol1vagukgeaxraabcsuayhdq637.jpg "" 244 "height=" 197 "/>

6. Select the publication type, because the Subscriber is Oracle, so here is the transactional publication:

650) this.width=650; "title=" clip_image007 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image007 "src=" http://s3.51cto.com/wyfs02/M00/6C/21/ Wkiom1vaf9zxbnscaabthetxlww541.jpg "" 244 "height=" 197 "/>

7. Select a publishing project, the published table must have a primary key:

650) this.width=650; "title=" clip_image009 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image009 "src=" Http://s3.51cto.com/wyfs02/M01/6C/21/wKiom1VAf93Qs_ Fyaabsviuvnvk079.jpg "" 244 "height=" 197 "/>

8. Direct Next Step:

650) this.width=650; "title=" clip_image011 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image011 "src=" http://s3.51cto.com/wyfs02/M02/6C/21/ Wkiom1vaf93twr8vaabeyvrl9tk746.jpg "" 244 "height=" 198 "/>

9. Tick Create snapshot Now:

650) this.width=650; "title=" clip_image013 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image013 "src=" http://s3.51cto.com/wyfs02/M00/6C/21/ Wkiom1vaf96r5wslaabkuwfugps476.jpg "" 244 "height=" 196 "/>

10. Configure Agent Security:

650) this.width=650; "title=" clip_image015 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image015 "src=" http://s3.51cto.com/wyfs02/M01/6C/1D/ Wkiol1vaguahiaroaabnwpdl77c766.jpg "" 244 "height=" 197 "/>

650) this.width=650; "title=" clip_image017 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image017 "src=" http://s3.51cto.com/wyfs02/M02/6C/1D/ Wkiol1vagufs9ruwaabkjjb5lqg772.jpg "" 244 "height=" 191 "/>

650) this.width=650; "title=" clip_image019 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image019 "src=" http://s3.51cto.com/wyfs02/M00/6C/1D/ Wkiol1vaguixvpfnaabf-appmy8788.jpg "" 244 "height=" 189 "/>

12. Tick Create Publication

650) this.width=650; "title=" clip_image021 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image021 "src=" http://s3.51cto.com/wyfs02/M01/6C/1D/ Wkiol1vaguibvh2baaa5ajvnzsi503.jpg "" 244 "height=" 197 "/>

13. Fill out the name of the release:

650) this.width=650; "title=" clip_image023 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image023 "src=" http://s3.51cto.com/wyfs02/M01/6C/21/ Wkiom1vaf-kqj20taabekwopsjs129.jpg "" 244 "height=" 197 "/>

14. Successful creation of the publication

650) this.width=650; "title=" clip_image025 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image025 "src=" http://s3.51cto.com/wyfs02/M00/6C/1D/ Wkiol1vagurzx5nwaabpehwdzuw528.jpg "" 244 "height=" 197 "/>

650) this.width=650; "title=" clip_image026 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image026 "src=" http://s3.51cto.com/wyfs02/M00/6C/1D/ Wkiol1vaguubfgrtaabaauru6ek456.jpg "" 129 "height=" 244 "/>

15. Create a subscription

650) this.width=650; "title=" clip_image027 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image027 "src=" http://s3.51cto.com/wyfs02/M00/6C/21/ Wkiom1vaf-xxi7qnaacbshni-k0420.jpg "" 244 "height=" 229 "/>

650) this.width=650; "title=" clip_image029 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image029 "src=" http://s3.51cto.com/wyfs02/M01/6C/21/ Wkiom1vaf-arbuppaabbhabkj_w714.jpg "" 244 "height=" 197 "/>

650) this.width=650; "title=" clip_image031 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image031 "src=" http://s3.51cto.com/wyfs02/M02/6C/21/wKiom1VAf-bAjuR_ Aabbn1emksi774.jpg "" 244 "height=" 198 "/>

650) this.width=650; "title=" clip_image033 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image033 "src=" http://s3.51cto.com/wyfs02/M00/6C/21/ Wkiom1vaf-fcittkaabwgnulrke840.jpg "" 244 "height=" 198 "/>

650) this.width=650; "title=" clip_image035 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image035 "src=" http://s3.51cto.com/wyfs02/M01/6C/1E/wKioL1VAgU_ Ypaxcaabvbciovge138.jpg "" 244 "height=" 198 "/>

650) this.width=650; "title=" clip_image037 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image037 "src=" http://s3.51cto.com/wyfs02/M02/6C/1E/ Wkiol1vagvcajlwaaabxw3nkaho838.jpg "" 244 "height=" 198 "/>

650) this.width=650; "title=" clip_image039 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image039 "src=" http://s3.51cto.com/wyfs02/M00/6C/1E/ Wkiol1vagvkgbrgkaabvfjmmuzu618.jpg "" 244 "height=" 192 "/>

650) this.width=650; "title=" clip_image041 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image041 "src=" Http://s3.51cto.com/wyfs02/M00/6C/21/wKiom1VAf-zyvp9BAABa_ J-5jtw823.jpg "" 244 "height=" 197 "/>

650) this.width=650; "title=" clip_image043 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image043 "src=" http://s3.51cto.com/wyfs02/M01/6C/21/ Wkiom1vaf-3a1ksgaabudm0frma883.jpg "" 244 "height=" 198 "/>

650) this.width=650; "title=" clip_image045 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image045 "src=" http://s3.51cto.com/wyfs02/M02/6C/21/ Wkiom1vaf-3wkd5waabtswniwvm445.jpg "" "height=" 244 "/>

650) this.width=650; "title=" clip_image047 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image047 "src=" http://s3.51cto.com/wyfs02/M02/6C/22/ Wkiom1vaf-7yhyuhaabatuxw5zi978.jpg "" 244 "height=" 197 "/>

650) this.width=650; "title=" clip_image049 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image049 "src=" http://s3.51cto.com/wyfs02/M00/6C/22/ Wkiom1vaf--jvlp0aabaus2wysc228.jpg "" 244 "height=" 196 "/>

650) this.width=650; "title=" clip_image051 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image051 "src=" http://s3.51cto.com/wyfs02/M01/6C/1E/ Wkiol1vagvezxt6eaaa9alxjsq4241.jpg "" 244 "height=" 198 "/>

650) this.width=650; "title=" clip_image053 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image053 "src=" http://s3.51cto.com/wyfs02/M02/6C/1E/ Wkiol1vagvitljm6aabdlah-iig342.jpg "" 244 "height=" 198 "/>

650) this.width=650; "title=" clip_image055 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image055 "src=" http://s3.51cto.com/wyfs02/M00/6C/22/wKiom1VAf_ Khffxiaabrb5z717y908.jpg "" 244 "height=" 198 "/>

650) this.width=650; "title=" clip_image056 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image056 "src=" http://s3.51cto.com/wyfs02/M00/6C/22/wKiom1VAf_ Odmq5iaabmwitppvo460.jpg "" 244 "height=" 204 "/>

SQL Server to Oracle subscription publishing is created.

Copy data tables on sqlserver2008 to Oracle database via subscription publication