.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

migration and upgarde from 2005 to 2008

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
we need to migrate the data from Houston to Seattle. plus, we need to upgrade 2005 server to 2008 at the same time, with the minimal downtime. The plan is to build the brand new 2008 server in Seattle, restore all databases (500 on the same server!) from full backup. when ready, shutdown applications in Houston, run diff backup and restore Seattle from diff. My question is about initial restore of master database in Seattle. is it a problem to restore 2005 master db on 2008 server?JulieShop

View Complete Post

More Related Resource Links

IO queuing issue after migration from 2005 to 2008

Hi,   Are there any functional changes to the number of outstanding IOs to a LUN from 2005 to SQL 2008? 2008 seems to have a limit of 128 outstanding IOs to a DB volume where SQL 2005 does not. I am struggling to find any SQL tuning parameters that would impact how the db can read/write to disk? Help/comments appreciated.    

Migration Issue to 2005 & 2008



Back in 2002, I wrote a program which utilized SQL-DMO to build "If Exists/Drop" and "Create" Scripts for me, and it's worked great until I migrated to 2005 then immediately to 2008.  I've briefly read up on switching to SMO and I'm going have to learn SMO unless someone knows of a tool that can create these scripts for me.  Does anyone know if SQL has a new tool for this or maybe a third party software.  I'm so busy with our flagship product, that it would really be terrible if I had to learn SMO right now and rewrite a script creator.

Thanks so much in advance.


Column Alias in ORDER BY Clause -- not supported in SQL Server 2005/2008 -- Causes enter migration



We are migrating from SQL Server 2000 to SQL Server 2008 R2 and our web application having thousands of SQL Statement with "Column Alias in ORDER BY Clause ".It is very difficulty to change all statements.

One of article says that SQL Server 2005/SQL Server 2008 not support "Column Alias in ORDER BY Clause and we have to replace with column name" because of this issue If we change Alias name to column name, we have do enter application/integrity testing. it is going to be big deal.

our client Decided to stop migration, Please some help is there any other alternative.



Migration of Analysis Services 2005 Cluster (Windows 2003) to Analysis Services 2005 (Windows 2008)



I need to migrate my SQL Server and Analysis Services cluster from Windows Server 2003 to Windows Server 2008, I have found an article for SQL ID (953200), but I cannot find anything for Analysis Services, does such a guide exist?




SQL 2005 upgrade to SQL 2008 R2 migration plan


Where can i get a outline for upgrading from 2005 to 2008 r2 (both standard).
The 'Copy Database' from ssms fails when it finds a database role in my 2005 database.  Not sure why.
I tried an IS project to transfer logins and it also fails.
I assume i need to transfer logins w/ sids or they won't match if i detach and copy files.
I had fewer problems moving from 2000 to 2005, sorry, frustrated.

Controls: Plan Your Migration to the Visual Studio 2005 Navigation Controls


Navigation is central to a well functioning Web application and it can be implemented numerous ways using today's technologies. This article highlights some of the key details of the new navigation controls that are part of the upcoming ASP.NET 2.0, and talks about how to design and implement one of these navigation controls today. This article contains a simple Web site that demonstrates the use of these navigation controls, pointing out some of the key items such as a breadcrumb control and things to watch for along the way. The article then describes how to implement a breadcrumb control today.

Dave Donaldson and Steven DeWalt

MSDN Magazine June 2004

Converting Crystal Report 2005 to 2008 - Please Tell Me I'm Stupid :)


Hello peeps,

  I have a series of Crystal Reports that I can view/edit using Visual Studio 2005 with no issues.  The method I'm using is to simply click on the *.rpt file and it opens in the VS crystal editor with no issues.  The problem I'm having is that we are upgrading to Visual Studio 2008, and when I open the *.rpt file in 2008 it opens as a binary file.  I guess I'm used to everything else in Visual Studio prompting me to convert the older version to the newer version, so I'm not sure what to do in this case.

  Is this normal?  Is there an easy conversion method that I'm simply overlooking?  Am I screwed?  Who invented liquid soap, and why?

Answers to any of these questions would be greatly appreciated...

Convert 2005 RDLC to 2008 using VS2010


Hi and thanks.


I'm getting an error on serveral reports that I built  in VWD2005 (express) using the reportviewer control.  Trying to edit the rdlc file in VS2010, VS2010 asks if i want to convert the file to RDLC 2008 format and I click ok.  When I build the site, I get this error (and of course also when the report is ran):


Error 1 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. C:\inetpub\wwwroot\mastercardlcm\Reports\WorkLists\OpenSRStatus.rdlc 1 


Here is my web.config concerning the RDLC assemblies, etc.

			<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
		<compilation debug="true">
				<add assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
				<add assembly="Microsof

VS 2005 to 2008


Hi folks

Am in the process learning C#, My instructor uses Visual C# 2005 Express and on my side I have Visual Studio 2008 Pro.

Do you think it will affect me in my Coding practice due to the different IDE Versions? Wha do I have to heed when coding?



SQL server 2005 2008


i cant install sql server 2005 nor 2008 on my windows 7 os

i read about somthing like adding new account when installing sql 2008 to provision the server or so, but didnt know how,,,

can you plz help me??


SQLServer 2008 Tools and SQL 2005 Cluster

I recently built a SQL Server 2005 cluster on the o/s Windows Server 2008 R2.  I have been attempting to connect to the cluster from my Windows 7 dekstop with my SQL Server 2008 Tool set.  I have been unable to attach to this cluster since its creation. The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip and the Browser surface is up and running. I ran Wireshark against the cluster and I could see that there was UDP conversations for ms-sql-m (SQL Port) but that was as far as it would get.  I am using a named instance so not using 1433, but I do see the cluster offering up high RPC ports but the client never responds after the initial UDP response. When I noticed that there was a two way conversation taking place, I went to a seperate machine and fired up SQL Server 2005 Tools and I was easily able to attach to the cluster.  So my question is - Are there any known incompatibilities between SQL Server 2005 cluster services and SQL Server 2008 Tool set?  I can use my 2008 tools to attach to a non-clustered SQL Server 2005 w/o issue.   Error when attempting to connect: A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is con

Xp_runwebtask issue after migration to sql 2008

Msg 2812, Level 16, State 62, Procedure sp_runwebtask, Line 16 Could not find stored procedure 'master..xp_runwebtask'. The statement has been terminated. This is wt i am getting after i upgraded from sql 200 to 2008 while i am inserting sth. help me

SQL 2005 migration issue

Hey everyone, I do not know anything about SQL, so hopefully someone can help me out. Installed SQL 2005 on a new server.  Restored a database from SQL7. The database I restored is called "train" for example and in that database is a user called "train_user" I cannot connect to the obdc data source using this "train_user".  I do not know if the password didn't carry over during the migration and don't even know how to check or change this password.  I don't know if this user needs certain privileges to be able to access the SQL server?  They are the db owner of the database that I restored.  The application I am trying to launch gives me the odbc error.  This info is stored in an ini file.  If I change this info to sa, then I can access the application. If I need to provide more info, I can do that, but hopefully someone understands what is going on or what I need to do to fix it. Here is the error code:  Error: 18456, Severity: 14, State: 5.

SQL 2005 db, edited in 2008

Hi all,I backupped a database from SQL Server 2005, edited it locally in my SQL Server 2008 Express (with Tools) and then tried to restore it back to the 2005 server again. This didn't work and gave several errors in the 2005 server, depending on the way I tried to restore it - or re-attach it. The errors are: Database cannot be opened becaus it is version 655. This server supports version 611 and earlier. The media family on device 'C:\Temp\backup2008\backup2008.bak' is incorrectly formed. SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)In other words: the database/backup is just fine, but SQL 2005 just doesn't swallow it. I have already confirmed that the compatability level on SQL 2008 Express (localhost) is set to '90', by using select * from sys.databases, which should mean that it is backwards compatible. I have also tried both restoring through the Management Studio and by script, as well as (re-)attaching the files. I just can't get it to work...Somewhere, it sounds logic. On another level I fail to see the point of the compatability level in the options if this is not possible. Any advice? Or do I just have to forget about SQL 2008 on my working machine and rollback to SQL 2005?

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

Replication between SQL Server 2005 and SQL Server 2008

Hi,    We were using SQL Server Transactional Replication between two SQL Server 2005 servers. Now we are going to upgrade the Publisher server to SQL Server 2008, Distributor Server remains as SQL Server 2005.     Can anyone let me know what is the challenges we need to face when configuring Replication between SQL Server 2005 and SQL Server 2008. Replication Method - Transactional Replication Distributor/Subscriber - SQL Server 2005 Publisher     -  SQL Server 208 Regards, Fazlu.

DTS_I_SUCCEEDEDHASHINGCACHE : Datacode 1075876066 : new Informationline in SQL 2008 vs. 2005

Hello guys, I've a simple question where i didn't found an answer yet: The processing time is in Seconds - but CPU Usage seconds or wait time seconds until the caching is finished ? Output of onlinebooks: The %1 processed %2!u! rows in the cache. The processing time was %3 seconds. The cache used %4!I64u! bytes of memory.   hope that anybody has the much sought-after answer...   thanks & greets from Austria | TiROL Alex
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend