Start a Conversation

Unsolved

B

1 Message

3757

October 7th, 2019 11:00

Migrating Data Collector Database to a New SQL Server

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

1 Rookie

 • 

3 Posts

May 19th, 2020 13:00

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

Moderator

 • 

7.6K Posts

May 19th, 2020 15:00

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.

1 Rookie

 • 

3 Posts

May 28th, 2020 05:00

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

1 Rookie

 • 

3 Posts

May 28th, 2020 05:00

The SQL version currently being used is SQL 2012

Moderator

 • 

7.6K Posts

May 28th, 2020 15:00

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.

No Events found!

Top