I am studying for the MTA Software Fundamentals exam and going through the Wiley Book.
It tells me to try and connect the Northwind Database via Visual Studio (2017), but every time I do so, I am faced with an error (I have attached a picture).
“The database file that you are attempting to connect is not compatible with the current instance of SQL Server”.
I then try to upgrade the database file then it says:
“Database file cannot be upgraded because it’s a non-release version, its not supported by this version of SQL Server.”
I have tried uninstalling SQL 2014 (express) and installing 2012 (express).
I have looked at most posts on the web with the same issue but can’t deduce what the answer is telling me to do.
I’m extremely new to SQL, does anyone have a basic explanation on how to fix this? The practical exercises from the Wiley book seem to be extremely useful, so I'm not giving up!
I can have tried SQL 2014 and 2012. I can't go any higher as I have windows 7.
I have tried downloading the Northwind databases direct from Microsoft but no luck.
I have tried to open this database up with SQL but its riddled with errors.
Same goes for 3 other sample databases that I have downloaded from github.
This is so hard
I worked over schema.sql so that it works for postgres. I found that once I got the schema right the data inserted without a problem. Maybe this is closer to what you want:
All things are lawful, but not all things are profitable.