Certifying New Versions of SQL ServerSQL Server Version - are hotfixes for previous versions implied?Use...
Could a warlock use the One with Shadows warlock invocation to turn invisible, and then move while staying invisible?
Possible issue with my W4 and tax return
A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?
What's the oldest plausible frozen specimen for a Jurassic Park style story-line?
Count repetitions of an array
Article. The word "Respect"
What is the difference between "...", '...', $'...', and $"..." quotes?
Non-Cancer terminal illness that can affect young (age 10-13) girls?
Do authors have to be politically correct in article-writing?
Why didn't the 2019 Oscars have a host?
What makes papers publishable in top-tier journals?
Website seeing my Facebook data?
Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?
Prevent Nautilus / Nemo from creating .Trash-1000 folder in mounted devices
Which RAF squadrons and aircraft types took part in the bombing of Berlin on the 25th of August 1940?
Boss asked me to sign a resignation paper without a date on it along with my new contract
How does Leonard in "Memento" remember reading and writing?
Why is the "Domain users" group missing from this Powershell AD Query?
What is the wife of a henpecked husband called?
Cat is tipping over bed-side lamps during the night
What can I do to encourage my players to use their consumables?
How big is a framed opening for a door relative to the finished door opening width?
Converting very wide logos to square formats
Why is that max-Q doesn't occur in transonic regime?
Certifying New Versions of SQL Server
SQL Server Version - are hotfixes for previous versions implied?Use Older Versions Of SQL Server Databases With 2012?Count duplicate versions of databases (SQL Server 2008 R2)Is Query Performance different for different versions of SQL Server?SQL Server Service Broker Compatability across versions?Safest way to uninstall the previous SQL Server versionsData sync from different SQL Server versions databasesReplication between two different SQL Server versionsRun SQL Server 2016 side-by-side with older versions?Moving Databases between Instances of different Versions of SQL Server
I manage development teams that support a legacy app with a SQLServer backend. The app is deployed on-premise so our customers maybe run any version SQLServer (minimum 2008).
We have an on-going challenge of certifying that our app runs on new versions of SQLServer or any new service pack. It's very time consuming for our QA to run a full regression of our suite of products so I'm wondering if anyone faces the same challenge and has found another way to certify new releases of SQLServer as they come out.
We've though of turning on profiler and then hammering the app to capture SQL and just replay that on a new SQLServer instance with the new version. Is there a better way?
BTW, we use a lot of SQL features such as triggers, procs, views, defaults etc.
Thx
sql-server
asked Nov 17 '18 at 1:14
sisdogsisdog
1112
add a comment |
I manage development teams that support a legacy app with a SQLServer backend. The app is deployed on-premise so our customers maybe run any version SQLServer (minimum 2008).
We have an on-going challenge of certifying that our app runs on new versions of SQLServer or any new service pack. It's very time consuming for our QA to run a full regression of our suite of products so I'm wondering if anyone faces the same challenge and has found another way to certify new releases of SQLServer as they come out.
We've though of turning on profiler and then hammering the app to capture SQL and just replay that on a new SQLServer instance with the new version. Is there a better way?
BTW, we use a lot of SQL features such as triggers, procs, views, defaults etc.
Thx
sql-server
asked Nov 17 '18 at 1:14
sisdogsisdog
1112
add a comment |
I manage development teams that support a legacy app with a SQLServer backend. The app is deployed on-premise so our customers maybe run any version SQLServer (minimum 2008).
We have an on-going challenge of certifying that our app runs on new versions of SQLServer or any new service pack. It's very time consuming for our QA to run a full regression of our suite of products so I'm wondering if anyone faces the same challenge and has found another way to certify new releases of SQLServer as they come out.
We've though of turning on profiler and then hammering the app to capture SQL and just replay that on a new SQLServer instance with the new version. Is there a better way?
BTW, we use a lot of SQL features such as triggers, procs, views, defaults etc.
Thx
sql-server
asked Nov 17 '18 at 1:14
sisdogsisdog
1112
I manage development teams that support a legacy app with a SQLServer backend. The app is deployed on-premise so our customers maybe run any version SQLServer (minimum 2008).
We have an on-going challenge of certifying that our app runs on new versions of SQLServer or any new service pack. It's very time consuming for our QA to run a full regression of our suite of products so I'm wondering if anyone faces the same challenge and has found another way to certify new releases of SQLServer as they come out.
We've though of turning on profiler and then hammering the app to capture SQL and just replay that on a new SQLServer instance with the new version. Is there a better way?
BTW, we use a lot of SQL features such as triggers, procs, views, defaults etc.
Thx
sql-server
sql-server
asked Nov 17 '18 at 1:14
sisdogsisdog
1112
asked Nov 17 '18 at 1:14
sisdogsisdog
1112
asked Nov 17 '18 at 1:14
sisdogsisdog
1112
asked Nov 17 '18 at 1:14
sisdogsisdog
1112
asked Nov 17 '18 at 1:14
sisdogsisdog
1112
1112
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Answers originally left as comments
I think you identified it in your question, regression testing. You maybe able to thin down the testing to just corner cases of the functionality. However if you are looking at more than “does it run” and wanting to test “how well does this run” a full test maybe your best option. – Aaron
To me, this is less of a question about the database, and more of an issue with your regression testing. You may want to explore ways to make your regression testing less labor intensive. – AMtwo
Also there aren’t that many things that work in 2008 and break in newer versions; the exceptions are limited to lists documented on Microsoft’s site, like this one for SQL Server 2016. So outside of those items, you should generally expect that moving to a new version should just work. Performance testing is something completely different, of course, and there aren’t any magic shortcuts aside from testing. Baselines are a good start. – Aaron Bertrand
answered 16 mins ago
Comment ConverterComment Converter
1,3071325
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222766%2fcertifying-new-versions-of-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Answers originally left as comments
I think you identified it in your question, regression testing. You maybe able to thin down the testing to just corner cases of the functionality. However if you are looking at more than “does it run” and wanting to test “how well does this run” a full test maybe your best option. – Aaron
To me, this is less of a question about the database, and more of an issue with your regression testing. You may want to explore ways to make your regression testing less labor intensive. – AMtwo
Also there aren’t that many things that work in 2008 and break in newer versions; the exceptions are limited to lists documented on Microsoft’s site, like this one for SQL Server 2016. So outside of those items, you should generally expect that moving to a new version should just work. Performance testing is something completely different, of course, and there aren’t any magic shortcuts aside from testing. Baselines are a good start. – Aaron Bertrand
answered 16 mins ago
Comment ConverterComment Converter
1,3071325
add a comment |
Answers originally left as comments
I think you identified it in your question, regression testing. You maybe able to thin down the testing to just corner cases of the functionality. However if you are looking at more than “does it run” and wanting to test “how well does this run” a full test maybe your best option. – Aaron
To me, this is less of a question about the database, and more of an issue with your regression testing. You may want to explore ways to make your regression testing less labor intensive. – AMtwo
Also there aren’t that many things that work in 2008 and break in newer versions; the exceptions are limited to lists documented on Microsoft’s site, like this one for SQL Server 2016. So outside of those items, you should generally expect that moving to a new version should just work. Performance testing is something completely different, of course, and there aren’t any magic shortcuts aside from testing. Baselines are a good start. – Aaron Bertrand
answered 16 mins ago
Comment ConverterComment Converter
1,3071325
add a comment |
Answers originally left as comments
I think you identified it in your question, regression testing. You maybe able to thin down the testing to just corner cases of the functionality. However if you are looking at more than “does it run” and wanting to test “how well does this run” a full test maybe your best option. – Aaron
To me, this is less of a question about the database, and more of an issue with your regression testing. You may want to explore ways to make your regression testing less labor intensive. – AMtwo
Also there aren’t that many things that work in 2008 and break in newer versions; the exceptions are limited to lists documented on Microsoft’s site, like this one for SQL Server 2016. So outside of those items, you should generally expect that moving to a new version should just work. Performance testing is something completely different, of course, and there aren’t any magic shortcuts aside from testing. Baselines are a good start. – Aaron Bertrand
answered 16 mins ago
Comment ConverterComment Converter
1,3071325
Answers originally left as comments
I think you identified it in your question, regression testing. You maybe able to thin down the testing to just corner cases of the functionality. However if you are looking at more than “does it run” and wanting to test “how well does this run” a full test maybe your best option. – Aaron
To me, this is less of a question about the database, and more of an issue with your regression testing. You may want to explore ways to make your regression testing less labor intensive. – AMtwo
Also there aren’t that many things that work in 2008 and break in newer versions; the exceptions are limited to lists documented on Microsoft’s site, like this one for SQL Server 2016. So outside of those items, you should generally expect that moving to a new version should just work. Performance testing is something completely different, of course, and there aren’t any magic shortcuts aside from testing. Baselines are a good start. – Aaron Bertrand
answered 16 mins ago
Comment ConverterComment Converter
1,3071325
answered 16 mins ago
Comment ConverterComment Converter
1,3071325
answered 16 mins ago
Comment ConverterComment Converter
1,3071325
answered 16 mins ago
Comment ConverterComment Converter
1,3071325
1,3071325
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222766%2fcertifying-new-versions-of-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
