I am running Dell Storage Manager 2016 R3 and need to migrate the DB off a 2008 R2 SQL Server (going to become an unsupported SQL Version soon).  I followed the guide under the section "Migrating a Microsoft SQL Server Database" step for step and when I got to the part to "Change the Data Source", after entering the required information and clicked next, the error response I got was that "Invalid Object Name TableNameYYY".

What I noticed was the table name included no Schema Name before it, like [compmsauser].[tablename], it was just the tablename.  Well, when you look at the database, all the tables are in the form of a [Schema].[TableName], so the "Change Data Source" option is not including the schema name when connecting to the database.  I know this because if I go create a [dbo].[DSM_CONFIG] table based upon the [Compmsauser].[DSM_CONFIG] table for example, I get the error above but for a new TableName.  This tells me that the "Change Data Source" tool is not using the Schema as part of its call, when it should be since the tables are stored that way.

How can I get passed this?  Is that a bug in 2016 R3?

Thanks