Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server Expand / Collapse
Author
Message
Posted Sunday, February 17, 2013 11:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, June 1, 2014 12:02 AM
Points: 93, Visits: 28
Please tell me what is SQLSvrStd2012 SNGL OLP.

Post #1421040
Posted Monday, February 18, 2013 1:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:20 AM
Points: 5,231, Visits: 5,106
Its a SQL Server 2012 Server Based License



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421079
Posted Monday, February 18, 2013 2:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, June 1, 2014 12:02 AM
Points: 93, Visits: 28
I wanted to upgrade my database from sql server 2005 to sql server 2012.
My front end is vb6.0
Is it fine?
Post #1421094
Posted Monday, February 18, 2013 2:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:20 AM
Points: 5,231, Visits: 5,106
Only you will be able to decide that.

Get a copy of the developer version of 2012, install it to a new server, restore a copy of the database, change your connection strings and test test test every and all functionality of the app, if everything works then fine, upgrade your dev test qa environments get business sign off then upgrade production, but ensure you sort all the leaglities out like licensing etc etc first.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421096
Posted Monday, February 18, 2013 2:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, June 1, 2014 12:02 AM
Points: 93, Visits: 28
Yes obviously, i will be getting licensed copy.
But my question is my application is too much big, so whether i will have to test each and every form?
Otherwise is any other solution for this.
I am not aware about any functions which are not available in 2012 and that available in 2005.
Post #1421111
Posted Monday, February 18, 2013 2:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:20 AM
Points: 5,231, Visits: 5,106
Run the upgrade advisor, see if it shows any depreciated features or things which work in 2005 which dont work in 2012 like old style joins etc.

Then you really should test all your forms in your application as you never know what could happen, 99% of the app may function correctly, but that 1% if its a mission critical piece of code and you didnt test it I would not like to think of the consequences, to yourself or your company. But if its only a small piece of functionality that doesnt work and you can release a patch for it and it doesnt impact the company then you should be ok, but never say never as stranger things have happened at sea (as the say).




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421113
Posted Tuesday, February 19, 2013 11:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 3:43 AM
Points: 49, Visits: 177
Thank you
Post #1421930
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse