Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
AWS Certified Database – Specialty (DBS-C01) Certification Guide

You're reading from   AWS Certified Database – Specialty (DBS-C01) Certification Guide A comprehensive guide to becoming an AWS Certified Database specialist

Arrow left icon
Product type Paperback
Published in May 2022
Publisher Packt
ISBN-13 9781803243108
Length 472 pages
Edition 1st Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Kate Gawron Kate Gawron
Author Profile Icon Kate Gawron
Kate Gawron
Arrow right icon
View More author details
Toc

Table of Contents (24) Chapters Close

Preface 1. Part 1: Introduction to Databases on AWS
2. Chapter 1: AWS Certified Database – Specialty Overview FREE CHAPTER 3. Chapter 2: Understanding Database Fundamentals 4. Chapter 3: Understanding AWS Infrastructure 5. Part 2: Workload-Specific Database Design
6. Chapter 4: Relational Database Service 7. Chapter 5: Amazon Aurora 8. Chapter 6: Amazon DynamoDB 9. Chapter 7: Redshift and DocumentDB 10. Chapter 8: Neptune, Quantum Ledger Database, and Timestream 11. Chapter 9: Amazon ElastiCache 12. Part 3: Deployment and Migration and Database Security
13. Chapter 10: The AWS Schema Conversion Tool and AWS Database Migration Service 14. Chapter 11: Database Task Automation 15. Chapter 12: AWS Database Security 16. Part 4: Monitoring and Optimization
17. Chapter 13: CloudWatch and Logging 18. Chapter 14: Backup and Restore 19. Chapter 15: Troubleshooting Tools and Techniques 20. Part 5: Assessment
21. Chapter 16: Exam Practice
22. Chapter 17: Answers 23. Other Books You May Enjoy

Converting a database using SCT

Once you have completed the assessments and decided on a target database, you can use SCT to assist in converting the database objects and code. SCT carries out the following tasks:

  • SCT installs an extension pack that contains common functions that can be used in converted database code. This extension pack is supplied within the SCT program.
  • SCT checks all DDL statements in the source database and attempts to recreate those in the language of the target. This includes tables, views, indexes, and more.
  • SCT attempts to convert the database's code into the target database's code.
  • For those who cannot automatically convert either using the native code of the target database or via the added extension pack functions, it provides a report that shows where the issues with the conversion are and what action you need to take to resolve them.

Figure 10.2 showed some example output of an assessment report for a SQL Server source...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime