Please excuse my ignorance but I am not a DBA and until my now database experience has been relegated to basic CRUD operations. I just used SSMA to migrate an Oracle database to an Azure SQL Server instance and have some questions
Q1. Every SQL Server database I have ever used has the dbo schema. This one contains the name of the Oracle schema it came from. So now instead of tables or procs being dbo.<table name or proc name> it is SDCS.<table name or proc name>.
Am I supposed to change all of these to dbo or just leave them as they are?
Q2. All of my procs are now in this format: SDCS.INSERT_BMA$INSERT_SDCS_PRIME and has several things such as SDCS.INSERT_SDCS$SSMA_Initialize_Package
Am I supposed to change the name to <schema>.INSERT_BMA and then just fix any errors within the procs?
Q3. I have a ton of procs related to Oracle such as ssma_oracle.db_clean_storage, ssma_oracle.db_check_init-packages, ssma_oracle.db_error_exact_once_row_check, etc.
What, if anything am I supposed to do with these?