cancel
Showing results for 
Search instead for 
Did you mean: 

Some of the objects in my script are not recognized by Migration Portal. What should I do?

Some of the objects in my script are not recognized by Migration Portal. What should I do?

Some of the objects in my script are not recognized by Migration Portal. What should I do? FYI, I have entered the DDL myself in the text area provided.

Accepted Solutions (0)

Answers (1)

Answers (1)

MuhammadIkram
EDB Team Member

 

Possibly, there is space or any character after the semicolon that terminates SQL statement, remove it and the issue will be gone. Below are a few examples of both valid and invalid  DDL statements for migration portal assessment. 

 

Following will be assessed by EDB Migration Portal 

create table test (col1 int, col2 int);
create table test1 (col1 int -- integer column
                  , col2 int   -- another integer column
		    );

Following Statements will not be assessed by EDB Migration Portal 

create table test2 (col1 int, col2 int);  -- space after terminating semicolon.
create table test3 (col1 int, col2 int);a-- Alphabet after terminating semicolon.
create table test4 (col1 int, col2 int);$-- Special character after terminating semicolon.
create table test5 (col1 int, col2 int);1-- Numeric  after terminating semicolon.
create table test6 (col1 int, col2 int);;-- Two semicolons after closing parenthesis.
create table test7 (col1 int, col2 int); -- No extra space or semicolon, just comments.

 

 

 

Ask a Question