CODEWITHSUNDEEP
sql-serverdatabasenulldbnull
user3430861
user3430861

Reputation: 182

Restoring Database SQL Server - data is null this method or property cannot be called on null values

I am trying to copy 2 databases from SQL Server 2012 to a new VM SQL Server 2017.

One of the databases was restored successfully but the other is giving me the below issues.

Databases both restored successfully, however 1 of the databases when I try to access the tables I am getting this error in SSMS "data is null this method or property cannot be called on null values"

Appreciate any help.

Upvotes: 1

Views: 542

Answers (1)

MysticHeroes
MysticHeroes

Reputation: 164

SQL Server 2017 has numerous features that aren't present in SQL Server 2012 and it is likely your version of SSMS doesn't support the newer version of SQL Server.

It's probable that when you open the database in SSMS it is trying to load Database Diagrams (now deprecated).

Are you able to run: 

USE [databasename]
GO

SELECT * FROM sys.objects

and see if your expected tables are in there?

Upvotes: 1

Related Questions