I was looking for a way / description how to upgrade an existing SQL Server 2000 database to SQL Server 2012.
How i fixed it:
SQL Server 2000 database has to be upgraded to 2005/2008 first.
If found the right hints how to do it in the SQL Server Forum here: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8ab5617e-0644-4434-96af-ebc04ba89f75/upgrading-from-sql-2000-to-2012-how
The procedure is described well in this document:
http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf
It says (page 241), that i have to first upgrade the database from 2000 to 2005/2008 and then to 2012.
This blog is about problems i encountered in everyday life and how i fixed them or worked around them. Sometimes i also just post things to let people out there know about something i think it might be of interest for others than me....
Showing posts with label Migration. Show all posts
Showing posts with label Migration. Show all posts
Friday, August 23, 2013
Friday, July 5, 2013
VS 2012 keeps prompting to switch to AnkhSVN source control when opening a project checked out from Team Foundation Server
We moved a C# project that was formerly under SVN to TFS. After the inital checkout from TFS to a clean local Folder, Visual Studio kept prompting to switch to AnkhSVN. Even after setting source control to TFS manually in VS, the message kept being displayed on opening the project.
How-i-fixed-it:
I found the solution here (thanks to Haddicus):
http://msdn.microsoft.com/en-us/library/fy98ye1k%28v=vs.90%29.aspx
How to (Really): Switch Source Control Plug-ins
How-i-fixed-it:
I found the solution here (thanks to Haddicus):
http://msdn.microsoft.com/en-us/library/fy98ye1k%28v=vs.90%29.aspx
How to (Really): Switch Source Control Plug-ins
Although you can do as the article suggest, you may find yourself in an infinite loop. The source control system will tell you (when you select a new source control option) that the current project uses a particular control system. If this is so, it will force close you out of the project itself. In my case, at least, the source control selection was hard coded into my primary project file, and wouldn't let me switch source control.
What you'll want to do to change this is to close your solution, and open up the solution file in a text editor. Look for a global section area, this area defines the version control software. For me to change providers, all I needed to do was remove this section (everything in the GlobalSection node)... For me ( I was using Subversion with AnkhSVN), so I removed this entire block:
GlobalSection(SubversionScc) = preSolution
Svn-Managed = True
Manager = AnkhSVN - Subversion Support for Visual Studio
EndGlobalSection
What you'll want to do to change this is to close your solution, and open up the solution file in a text editor. Look for a global section area, this area defines the version control software. For me to change providers, all I needed to do was remove this section (everything in the GlobalSection node)... For me ( I was using Subversion with AnkhSVN), so I removed this entire block:
GlobalSection(SubversionScc) = preSolution
Svn-Managed = True
Manager = AnkhSVN - Subversion Support for Visual Studio
EndGlobalSection
Subscribe to:
Posts (Atom)