Francisco Tapia
fhtapia at gmail.com
Mon Sep 10 09:52:04 CDT 2012
Congratulations on your retirement! It's awesome that you get to take some time for fun stuff for your :). If your plan is to work on sql2012, you wouldn't need any other versions, you can always upsize your previous sql databases to 2012, however, if you were planning on supporting clients with pre-sql2012 then you'll need any version you plan on supporting if you plan on loading their database on your system. If you are not loading their database on your system and all you are doing is making modifications (ie, scripting) I don't think you'd need to change anything, just change the database version in your database properties and ensure you are not using any 2012 features when addressing a sql server 2005 script. Happy times, enjoy! -Francisco -------------------------- You should follow me on twitter here <http://twitter.com/seecoolguy> Blogs: SqlThis! <http://bit.ly/sqlthis> | XCodeThis!<http://bit.ly/xcodethis> <http://db.tt/JeXURAx> On Sat, Sep 8, 2012 at 11:35 AM, Arthur Fuller <fuller.artful at gmail.com>wrote: > This is a very general question, I realize, and although I still have > numerous gigs available, why do I need versions of SQL before SQL Server > and Visual Studio? Since I began my retirement, I retain an interest in > these technologies, but have no current clients to support, so am I free to > do a backup of everything and then reformat the drive, re-install Windows 7 > and then only the most current parts? The reason I ask is that I still want > various 3p products to work, such as the Red Gate stuff for SQL Server. I'm > guessing that such things will automatically install what they need, but am > unsure about this. > > I want to pare down my environment to the minimal set of stuff that I > actually use, I have a list of these components ready. Why would I need SQL > 2005 for example? All I'm interested in currently is SQL 2012; do I still > need an instance of SQL 2008, SQL 2008 R2, SQL 2005 etc.? And why do I have > so many instances of various versions of Visua Studio run-times? > > I'll back everything up before I flush the proverbial toilet, but why must > I have all these instances? > > -- > Arthur > Cell: 647.710.1314 > > Prediction is difficult, especially of the future. > -- Niels Bohr > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >