sql server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » sql server

sql server

Rate Topic

Display Mode

Topic Options

Author

Message

Shukla

Posted Sunday, February 17, 2013 11:41 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 11:10 PM
Points: 92, Visits: 27

Please tell me what is SQLSvrStd2012 SNGL OLP.

Post #1421040

anthony.green

Posted Monday, February 18, 2013 1:45 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

Shukla

Posted Monday, February 18, 2013 2:06 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 11:10 PM
Points: 92, Visits: 27

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

anthony.green

Posted Monday, February 18, 2013 2:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1421096

Shukla

Posted Monday, February 18, 2013 2:53 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 11:10 PM
Points: 92, Visits: 27

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

anthony.green

Posted Monday, February 18, 2013 2:57 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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).

Post #1421113

ratheesh4sql

Posted Tuesday, February 19, 2013 11:03 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 5:01 AM
Points: 48, Visits: 151

Thank you

Post #1421930

« Prev Topic | Next Topic »

Permissions