Click here to Skip to main content
15,890,282 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: CCC Pin
OriginalGriff8-Aug-21 22:57
mveOriginalGriff8-Aug-21 22:57 
GeneralRe: CCC Pin
pkfox8-Aug-21 23:03
professionalpkfox8-Aug-21 23:03 
GeneralRe: CCC Pin
Rich Leyshon8-Aug-21 23:18
Rich Leyshon8-Aug-21 23:18 
GeneralRe: CCC Pin
pkfox8-Aug-21 23:22
professionalpkfox8-Aug-21 23:22 
GeneralRe: CCC Pin
OriginalGriff9-Aug-21 0:07
mveOriginalGriff9-Aug-21 0:07 
GeneralRe: CCC Pin
pkfox9-Aug-21 1:44
professionalpkfox9-Aug-21 1:44 
GeneralRe: CCC Pin
OriginalGriff9-Aug-21 1:49
mveOriginalGriff9-Aug-21 1:49 
GeneralTry, Fail, Try, Fail, Try, Fail - SQL Restore 19 to 17 Pin
kmoorevs8-Aug-21 7:52
kmoorevs8-Aug-21 7:52 
I did this to myself, working away from the office yesterday on the laptop. The customer admin for one of our web-based systems is in quarantine at the very time when an annual purge/staffing adjustments is due by Monday morning. I volunteered to help them out the jam, requiring around 6 hours of my time but meant that my best opportunity would be yesterday working offline on a recently rebuilt laptop.

It started when I realized that the laptop only had sql server 2019 (trying to keep it light) and the database I had pulled from the server is 2017. I've been down this one-way road before but I didn't have a choice. To be honest, I naively considered that maybe if I kept it at the 2017 compatibility setting, I might be allowed to somehow get the database back to 2017 and simply get it back on the server and call it a weekend. (the app isn't normally used on the weekends) Sadly, after all these years, sql server still cannot backup to a previous version or restore from a newer version...at all. Sigh | :sigh:

What I tried:
0: straight up restore...straight up failed!
1: export/import data-tier (.bacpac)...failed!
2: ssms copy database wizard...failed!

The way I see it, all is not lost as there are a couple more options: (in order of likely outcomes)
0: install 2019 on the server and change the appropriate connection strings
1: manually copy records from a 2019 instance to the 2017 instance (around a dozen possible affected tables) locally
2: write a custom script to do #1

I'm going to let this one sit for a bit while I cure the new Traeger wood-pellet grill. The missus is going to do something with a chicken and a beer can later. Funny thing, their instruction manual uses a six-pack as a step indicator...by beer six, you are ready to start cooking! Laugh | :laugh: This should be interesting! Smile | :) Anyway, I'm sure I'll find a solution! Laugh | :laugh:
"Go forth into the source" - Neal Morse
"Hope is contagious"

GeneralRe: Try, Fail, Try, Fail, Try, Fail - SQL Restore 19 to 17 Pin
RickZeeland8-Aug-21 8:39
mveRickZeeland8-Aug-21 8:39 
GeneralRe: Try, Fail, Try, Fail, Try, Fail - SQL Restore 19 to 17 Pin
kmoorevs10-Aug-21 8:41
kmoorevs10-Aug-21 8:41 
GeneralRe: Try, Fail, Try, Fail, Try, Fail - SQL Restore 19 to 17 Pin
Marc Clifton8-Aug-21 14:05
mvaMarc Clifton8-Aug-21 14:05 
Generalnow I understand OOP programming Pin
Southmountain7-Aug-21 15:42
Southmountain7-Aug-21 15:42 
GeneralRe: now I understand OOP programming Pin
Maximilien8-Aug-21 2:12
Maximilien8-Aug-21 2:12 
GeneralRe: now I understand OOP programming Pin
Gary R. Wheeler9-Aug-21 12:43
Gary R. Wheeler9-Aug-21 12:43 
GeneralRe: now I understand OOP programming Pin
PIEBALDconsult8-Aug-21 6:47
mvePIEBALDconsult8-Aug-21 6:47 
GeneralRe: now I understand OOP programming Pin
OriginalGriff8-Aug-21 7:45
mveOriginalGriff8-Aug-21 7:45 
GeneralRe: now I understand OOP programming Pin
Southmountain8-Aug-21 11:11
Southmountain8-Aug-21 11:11 
GeneralRe: now I understand OOP programming Pin
OriginalGriff8-Aug-21 11:21
mveOriginalGriff8-Aug-21 11:21 
GeneralRe: now I understand OOP programming Pin
Southmountain8-Aug-21 13:19
Southmountain8-Aug-21 13:19 
GeneralRe: now I understand OOP programming Pin
Eddy Vluggen8-Aug-21 7:57
professionalEddy Vluggen8-Aug-21 7:57 
GeneralRe: now I understand OOP programming Pin
Southmountain8-Aug-21 13:16
Southmountain8-Aug-21 13:16 
GeneralRe: now I understand OOP programming Pin
Peter Shaw8-Aug-21 23:52
professionalPeter Shaw8-Aug-21 23:52 
GeneralRe: now I understand OOP programming Pin
Southmountain9-Aug-21 4:07
Southmountain9-Aug-21 4:07 
GeneralRe: now I understand OOP programming Pin
11917640 Member 8-Aug-21 19:12
11917640 Member 8-Aug-21 19:12 
GeneralRe: now I understand OOP programming Pin
Southmountain9-Aug-21 4:05
Southmountain9-Aug-21 4:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.