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

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

Upgrade Advisor SQL2008 - Profile Trace Files

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

I am not sure if the Upgrade Advisor is paying any attention to my Profile Trace.

I have created a Profile Trace against a SQL2000 instance using SQL2000 Profiler, and the SQLProfilerTSQL_Replay template.

I ran the Microsoft SQL Server 2008 Upgrade Advisor  and got it to analyse the trace file.

I am just not sure the 'Advisor' is actually doing anything with the trace file, because the only 'progress action' that is performed is: 'Analyse SQL Server', which is always run, even when you don't specify the trace file.

Is that all I am supposed to see, or should their be an extra 'Progress Action' (and report) for the Trace File analysis.

Appreciate your help with this. 


View Complete Post

More Related Resource Links

Error on Upgrade Advisor

Hi there, I tried to run Upgrade Advisor on two SQL 2000 servers, but the wizard keeps failing when it reaches 22% while analyzing the Database Engine. I downloaded the latest version, but still receive the same error... Error: "SQL BPA command line has encountered a problem and needs to close" Both servers are Windows 2003 Enterprise Edition SP1 with SQL 2000 Enterprise Edition SP4. Does anyone have an idea what I can do to fix this problem. Thanks!!

sql server 2000 to SQL Server 2008 in place upgrade -- Upgrade advisor help

Hello Every body Please advise me the steps i am following are correct I need to improve some more... I want upgrade from sql server 2000 to SQL Server 2008, Plese confirm the steps 1.Setup Test SQL Server 2000 similar to Production SQLServer 2000. 2.Setup other server with SQL Server 2008. 3.Install the Upgrade advisor in SQL Server 2008 system 4.Select the  Play back(under "sql server 2000 server") in Upgrade advisor tool  and fill the SQL Server2000 Server name and authontication. 5.Click on Capture play back(take the all the backups run some top 10 queries or application on top of SQL server 2000) 6.Please in shared drive(whcih can access by the SQL Server 2008 server) 7.Now click the "setup the test server" 8.Now click the upgrade test server 2008.. 9.camapre the trace files 10.View the Trace files differance. some body help me and plese confirm those steps are correct...I am in right direction..SNIVAS

OK to uninstall microsoft sql server 2008 r2 upgrade advisor?

After upgrading to microsoft sql server 2008 r2, is it OK to uninstall microsoft sql server 2008 r2 upgrade advisor and microsoft  sql server 2008 r2 setup support files?

Replay Trace and Upgrade



We are looking at upgrading some of our SQL 2000 related apps to a SQL 2008 r2 box.

Someone has asked if we can do the following (which I have never tried before)

Take a backup of the SQL 2000 database

Start a trace on the 2000 database

restore the backup on a 2008 server - change compatibility mode etc

replay the trace on the 2008 database

use Data Compare to show the database are the same.

Use this to demonstrate that had the application used the 2008 database they would have had the same data as they would have done having used the 2000 database.

Note: This isn't an attempt to shortcut development or testing – it's an attempt to

Upgrading SQL2008 Cluster Active/Active Failing to upgrade 2nd node


I upgraded the 1st node of a SQL2008 Cluster on Windows 2003 sp2, and this was after correcting a SQL2008 Cluster install by uninstalling and removing a node.   It was stable when I began the R2 install.  The first node went as planned, but it will not move past the setup phase where it does the install of the setup files, and the log shows this:

Running Action: PostMsiTimingConfigAction
2010-11-04 09:52:52 Slp: The object state property 'workflow' is null/empty.
2010-11-04 09:52:52 Slp: Error: Action "PostMsiTimingConfigAction" failed during execution.
2010-11-04 09:52:52 Slp: Completed Action: PostMsiTimingConfigAction, returned False


I had previously tried to install R2 which led to some corruption and required me to correct the 2008 install.  Following the instructions here :



Unable to connect Traditional VB6 Application to SQL2008 - After Upgrade from SQL2005



We have  VB6 application working and it uses ADO to connect to SQL2005.   We have upgraded server to SQL2008
Now VB6 application is unable to connect,  the Code Line object_ADOConnection.Open  Fails,  meaning it gets hung-up.

Any Directions what could be wrong or anything that needs to change in code.?


Slowness writing to database after upgrade from SQL2005 to SQL2008/R2



We have recently upgraded our SQL server and moved from SQL2005 to SQL2008/R2.

A program we use continuously inserts rows of data into a table in the database.

The process used to write approximately 200 lines of data per second, but since upgrading it will only write one line per second.

We have tried to mirror the configuration of the server as accurately as possible, but does anyone know of a setting that could be causing the data to be written so slowly?

Kind Regards,


2008 R2 Upgrade Advisor from command prompt fails


I've run the 2008 R2 Upgrade Advisor (from the GUI) successfully, finding several upgrade issues in a run which takes around 20 minutes. When I run the command prompt version of the tool, using the config file created by the GUI run, it returns immediately with no error message and having created no report. Here's the command:

C:\>"C:\Program Files\Microsoft SQL Server 2008 R2 Upgrade Advisor\UpgradeAdvisorWizardCmd.exe" -ConfigFile "C:\Documents and Settings\MyLogin\My Documents\SQLServer 2008 R2 Upgrade Advisor Reports\MyServer\Config.xml"

Why is the command doing nothing? I need this to automate my pre-upgrade analysis work.

Solution (sln) & Project Files rptproj in SQL2008



I'm working on a Team of 12 report developers and we have a single Solution defined by our IT Manager. we all have a local copy of this Solution (lets call it Reports2008), which we are developing our own reports into. 

It's structured is roughly defined below,


       Department 1

             Shared Data Sources

             Shared DataSets


       Department 2

             Shared Data Sources

             Shared DataSets


       Department 3 

             Shared Data Sources

             Shared DataSets


       Department 1 

             Shared Data Sources

             Shared DataSets



Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:

Code Optimized Web Development Profile (VS 2010 and .NET 4.0 Series)

When you first run VS 2010 it prompts you to select an IDE profile to use. The profile you select will configure how tool windows are displayed/docked in the IDE by default and set the default keyboard shortcuts. You can then customize any of these settings by using the Tools->Options menu within the IDE and then override/change them. You can also later reset your profile and pick a different one by choosing the Tools->Import and Export Settings menu command.

SharePoint document migration challenges when migrating files and folders

There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.

Combine, minify and compress JavaScript files to load ASP.NET pages faster

Websites are getting more interactive these days and most of this interactivity comes from JavaScript. People are using different JavaScript libraries and frameworks to make their websites more interactive and user friendly.

Configuring Profile Image Export in SharePoint 2010

It's no secret that I am thrilled with the new social features of SharePoint 2010. I am most excited about the new Profile Picture handling. I strongly believe that the more we can show the faces of our colleagues to one another the more connected we will feel. Clearly Microsoft feels that way as witnessed by the many features that make use of the Profile Image like the Activity Feed and Colleagues list

PrintPocketCE Print Pocket Excel, Pocket Word and email files

Version 3.560 (May 15, 2009):

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.

Adjusted PocketJet printer paper feed commands

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):

Fixed error in Canon printer support

Fixed COM0 port selection

Version 3.556 (June 15, 2008):

Added support for Brother MW-260

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):

Added Panasonic JT-H200PR printer support

Added Pocket Spectrum printer support

Fixed problem with WM5.0 "inverted image" problem

Conversion of text files from ANSI to UTF-8

reading and writing text files in ANSI format and
writing html-files in Charset ISO-8859-1 (Western Europe).

How to transfer files between computer and mobile device using bluetooth

What is Bluetooth? How can I have it on my computer?

Bluetooth wireless technology is a communication technology that allows two devices to communicate wirelessly. Most of the notebooks are nowadays equipped with bluetooth. For those notebooks or computers that don't, you can use a bluetooth dongle to add the functionality and it just costs you around $5. Although higher price range bluetooth dongles are available but it makes no sense of buying them if you just plan to connect your mobile device to the computer. Look for one that has Bluetooth v2.0 + EDR (Enhance Data Rate) supporting speeds of upto 3Mbps and with Vista support. You can easily have one of that kind in just $5.

Setting up bluetooth to work on your computer

Just Insert the bluetooth dongle in the USB.
It should get detected by your Operating System and should be ready to use. In case it is just detected as a new hardware, you need to install drivers for it that came with your bluetooth dongle (You can try Google to find the drivers).
Once drivers are installed, a bluetooth notification icon will appear in your system tray.
Right Click on it to access Settings (This may vary with your bluetooth dongle).
Make sure you have turned Discovery On (It allow others to see your computer).
Switch On the bluetooth on the mobile device.
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