Click here to Skip to main content
15,437,758 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
MemberRich 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
Memberkmoorevs8-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
Memberkmoorevs10-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
MemberSouthmountain7-Aug-21 15:42 
GeneralRe: now I understand OOP programming Pin
Maximilien8-Aug-21 2:12
MemberMaximilien8-Aug-21 2:12 
GeneralRe: now I understand OOP programming Pin
Gary R. Wheeler9-Aug-21 12:43
MemberGary R. Wheeler9-Aug-21 12:43 
GeneralRe: now I understand OOP programming Pin
PIEBALDconsult8-Aug-21 6:47
professionalPIEBALDconsult8-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
MemberSouthmountain8-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
MemberSouthmountain8-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
MemberSouthmountain8-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
MemberSouthmountain9-Aug-21 4:07 
GeneralRe: now I understand OOP programming Pin
11917640 Member 8-Aug-21 19:12
Member11917640 Member 8-Aug-21 19:12 
GeneralRe: now I understand OOP programming Pin
Southmountain9-Aug-21 4:05
MemberSouthmountain9-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.


Straw Poll

When building an application, when is the most important time to consider the User Experience?
They are the ones we write code for, right?
  Results   665 votes