Hi Team,
When i am trying to run the assessment report using SSMA for oracle console, I am getting the following error .
One or more objects specified as a command params were not found in metabase: HR.

I am able to generate the SSMA assessment report using SSMA for Oracle UI.

I have attached the screen shot and sample SSMA sample config scripts for the reference.

Need your support to resolve the issue.

Regards,
Vimal

Sample Console Scripts.zip

The workload assessment is reached from https://datamigration.microsoft.com/scenario/oracle-to-azuresqldb which talks about Oracle to SQL migration and yet this particular doc doesn't list Oracle as Source on-prem? Can we add that please or is this not relevant anymore?

Hey,

Version 5.5.5310.2 of DMA is sorting the schema extraction the way that first

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[sch].[HistTableX]') AND type in (N'U'))
BEGIN
CREATE TABLE [sch].[TableX](
...
	[TenantID] [int] NOT NULL,
	[ID] [bigint] NOT NULL,
	[TransFrom] [datetime2](7) GENERATED ALWAYS AS ROW START NOT NULL,
	[TransTo] [datetime2](7) GENERATED ALWAYS AS ROW END NOT NULL,
WITH
(
SYSTEM_VERSIONING = ON ( HISTORY_TABLE = [sch].[HistTableX] )
)

...

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[sch].[HistTableX]') AND type in (N'U'))
BEGIN
CREATE TABLE [sch].[HistTableX](

...

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[sch].[HistTableX]') AND name = N'CIX_HistTableX')
CREATE CLUSTERED INDEX [CIX_HistTableX] ON [sch].[HistTableX]
(
	[TenantID] ASC,
	[ID] ASC,
	[TransFrom] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [S_TenantID]([TenantID])
GO

After the first block executes, the table [sch].[HistTableX] will be created with the clustered index with the period columns ([Transfrom] and [TransTo] in our case).

This will actually create a result message like:

"Cannot create more than one clustered index on table 'sch.HistTableX'. Drop the existing clustered index 'ix_HistTableX' before creating another."

We are relying on the proper clustered index being present on the history tables backing temporal tables as we actively querying those.

Please extract/generate the DDL taking care of this requirement - so the history table creation with it's corresponding clustered index should preceed the creation of the table it's backing.

Thanks

Just created a new Windows Server VM. Ran into a few errors while running the script.

1. Had to create C:\github\bin and C:\ora2pgTemp folders manually.
2. Oracle requires acceptance of OTN terms before downloading.

Hi, I got this error message when running the PS script - "**Could not create SSL/TLS secure channel"

After some research on the internet and thanks to Dr. BING I was able to solve the error with this line entered after the Param declaration

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

got this thanks to ZitRos - denoland/deno_install#51

A link in "Worksheet in workload assessment tool" is pointing to incorrect link on McDonald's site.

Worksheet available here -
https://github.com/Microsoft/DataMigrationTeam/tree/master/Data%20Workload%20Assessment%20Model%20and%20Tool/Workload%20Assessment%20Tools

Here is the link to Information Asset Classification link - that redirects to MCD web site requiring employee login -
https://dmc.accessmcd.com/content/mcmac/storagearea/wa1/b296d62eeb3a8efd2d2dc0760d533fd3/2553976.AssetPar.Single.File.0.tmp.x.pdf

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Maybe I am missing the obvious, but where is the actual Workload Assessment Model And Tool? It's folder contains a nice PDF about it and some sample Excel output. But I'm not seeing the tool itself??

Executed the scripts @ DataMigrationTeam/Teradata to Azure SQL DW Scripts/Teradata to Azure SQL DW Scripts/02-ADF/

The document and scripts are updated till Creating pipelines.
Don't see any script/documentation - for executing the pipelines.

Trying to copy the data in a Teradata database table to Azure sql datawarehouse - can you please help on the further steps ASAP.

Thanks

Scripts located in https://github.com/microsoft/DataMigrationTeam/tree/master/Oracle%20Inventory%20Script%20Artifacts/Oracle%20Inventory%20Script%20Artifacts only support a single instance. Is it possible for you to upgrade scripts to support more complex setup?