|
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. 
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!  This should be interesting!  Anyway, I'm sure I'll find a solution!
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
You might be interested in How to migrate a SQL Server database to a lower version[^]
Based on my experiences long ago with SQL Server 2012:
if your database is large using SQL Server Management Studio with large scripts probably won't work, in this case I would recommend using SQLCMD.
But of course it would be even better to dump SQL Server in favor of PostgreSQL 
|
|
|
|
|
Thanks Rick!  Good advice and a trick I'll file away for future reference.
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
I think #2 would be your best option, having had to do something similar once.
[rant] While we're on the subject, I'm so annoyed that SSMS doesn't support 2019 for anything other than reading the DB and schema. That new fangled SSMS, the one that looks like it was built to be cross-platform by someone who has no clue what people want to do as a DB Admin, is a POS. I ended up installing DBeaver but it has some problems with SQL 2019, but is at least a lot more usable than that newfangled crap Microsoft put out as an "upgrade" of SSMS. [/rant]
|
|
|
|
|
I have this old GE refrigerator since 2004 that does not freeze now. I unplug it from power and open up the freeze section.
with my multimeter, I tested my de-frost component and it did not function. I ordered a new component from GE wit with the same model no.
now it works and hope it will work for another 10 years...
diligent hands rule....
|
|
|
|
|
lucky that you did not have to "delete this" on your fridge
CI/CD = Continuous Impediment/Continuous Despair
|
|
|
|
|
See my sig.
Software Zen: delete this;
|
|
|
|
|
Modularity at least.
OOP would be if you could replace the de-frost with the light.
|
|
|
|
|
Or derive from the fridge to make the freezer and a cooker.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I understand Activity Pattern now
diligent hands rule....
|
|
|
|
|
Good for you.
I don't give a monkeys about Patterns ... they are normally misused
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
that is what I do daily as a developer
diligent hands rule....
|
|
|
|
|
That's what most companies actively try to prevent, even while claiming to be pro-environment.
I'm not buying a new one. Indesit can go elephant itself, as can it's mother company with their enviromental nonsense. A 2 dollar part, on a 100 dollar print, and they even refuse to send a new print. Even if European law demands it two months later.
Bastard Programmer from Hell 
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
after I plug in this defrost heater and power it on, it works silently. GE appliance is great and I like this design
diligent hands rule....
|
|
|
|
|
I had a not to dissimilar discussion with Epson.
All of their packaging claim they get the "Eco Green Technology Company Award" time and time again.
Yet when the nozzles gunked up on my BX300X multifunction printer, and it could no longer print, the Scanner and Fax machine on it where also disabled.
When I contacted Epson to ask if there was a way to still use the Scanner and Fax I was told point blank by their support staff that, that was the way it worked, now be a good boy throw the old out and buy a new one....
They where NOT AMUSED when I republished everything their support folks had told me on twitter, and even threatened to sue me if I didn't remove it, but I stood firm, left it there, and eventually it vanished from sight.
I'm pleased to say however, that as of the beginning of this year, I actually managed to get the scanner and fax working again, it turns out the code to disable it was in Epson's own scanner software, I've since found out that the Open Source "NAPS2" scanner software runs perfectly well on windows, and I now have 3 A4 flat bed scanners, my old Epson BX300 an even older Epson before that (That had the same problem) and the HP Laser jet multi function I purchased to replace the 2 old Epsons.
|
|
|
|
|
I am still working on the configuration of my LexMark fax machine(printing and copying are fine). I can not send out Fax and it always signals me that it is not connected...
diligent hands rule....
|
|
|
|
|
Southmountain wrote: now it works and hope it will work for another 10 years
So, this is not OOP.
|
|
|
|
|
this is the effect of using OOP
diligent hands rule....
|
|
|
|
|
Actually, that's "component-based" (programming): as in VB 6.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
if you regard this component has a function and an interface, it may be a class...
diligent hands rule....
|
|
|
|
|
At the risk of subjecting you all to 9gag, this is funny : https://9gag.com/gag/aMK72BP[^]
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
I think that sentence violates the Geneva Convention.
|
|
|
|
|
That's cold man.
Repo Man
|
|
|
|
|
And that's when the crime rate dropped to 0
|
|
|
|
|
So if you get caught committing a crime in Finland, they give you the skills to do a better job next time? 
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
