Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upgrading SQL from 2008 to 2012
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01629103
Message ID:
01629120
Views:
35
>>A customer is using my VFP 9 application with SQL Server 2008 R2 database. All have been working well for over a year.
>>
>>The IT just sent me the following message:
>>
>>
>>We are going to upgrade the 2008 R2 from SP2 to SP4 on Monday the 21st at 3pm until 7pm. We’ll take a snap of the server (virtual 
>>technology) and then move forward with the SQL patching. If SQL 2012 is supported, we’ll want to move forward with spinning up a new 
>>SQL 2012 server and migrate H D A to the new server. What services will we need from you to get that done.
>>
>>
>>A few questions, please:
>>1. What is 'spinning a up a new SQL 2012'?
>
>I think they just meant to go with SQL 2012.
>
>
>>2. What is "H D A"
>>3. When they do this type of work, does the SQL Server name stay the same? Because my VFP 9 app relies on the SQL Server name and the DB name.
>
>No, the SQL Server name may change.
>
>
>>4. When they do this type of upgrade, do they change SQL Server logins?
>>
>
>
>They may change the logins.
>
>>TIA for any input.

Their IT person told me that neither server no login will change. So we will see. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform