SQL error during migration to new server

Implemented

SQL error during migration to new server

avatar
sbemister1

Hello,

I'm using this article: https://docs.devolutions.net/kb/remote-desktop-manager/how-to-articles/sql-server-database-migration/#solution-2-bacpac to migrate our SQL datasource to a new server.

old server is Server 2012R2 running SQL server 2012

new server is Server 2022 running SQL server 2022

both are VM's on the same ESXi cluster

RDM client version 2023.3.24

While attempting to perform the step "Export Data-tier application" I receive the following error. Not sure how to make this work. Any help would be appreciated.

So, 2 questions:

  1. any idea why I'm getting this SQL error?

  2. can I just backup the DB and restore on the new server? I did try this but, when I tried to connect to it, said login failed (which I get because there's no users defined in the Security\\Logins area).

TITLE: Microsoft SQL Server Management Studio

------------------------------

One or more unsupported elements were found in the schema used as part of a data package.

Error SQL71564: Table Table: [dbo].[NotifierGroupToNotifier] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.

Error SQL71564: Table Table: [dbo].[UserInfoHistory_Archive] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.

Error SQL71564: Table Table: [dbo].[ConnectionLog_Archive] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.

Error SQL71564: Table Table: [dbo].[UserBehaviorAnalyticsNotificationAcknowledger] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server.

Error SQL71564: Element User: [TEMPLE\AcronisBU] has an unsupported property AuthenticationType set and is not supported when used as part of a data package.

Error SQL71564: Element Login: [TEMPLE\AcronisBU] has an unsupported property IsMappedToWindowsLogin set and is not supported when used as part of a data package.

(Microsoft.SqlServer.Dac)

All Comments (3)