Migrating Data Collector Database to a New SQL Server

Question

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

BlueFalcon619 · Answer

Did you ever find a solution to this? I am running into the same problem.

DELL-Sam L · Answer

Hello BlueFalcon619,

Which Compellent system do you have and what is the current SCOS? Which SQL version are you currently using, and which are you wanting to move to?

Please let us know if you have any other questions.

BlueFalcon619 · Answer

We attempted to upgrade from DSM 2018 R1 to DSM 2019 R1. We have a variety of SC8000, SC9000 compellents as well as SC4020.

BlueFalcon619 · Answer

The SQL version currently being used is SQL 2012

DELL-Sam L · Answer

Hello BlueFalcon619,

Here is the link to the 2019 administrator guide and on page 616 it has the steps that is needed to migrate the database. https://dell.to/2zx9UFn

Please let us know if you have any other questions.

Compellent

Was this post helpful?