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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Migration from 2000 to 2005 SQL Server Tips and precaustions

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

Hi All,

 

Request to provide the tips and details for migrating data from SQL 2000 to 2005.

Thanks in advance




View Complete Post


More Related Resource Links

sql server 2000 vs 2005

  

i would like to ask what the difference between sql server 2000 and 2005 


SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64)

  
Hi All I don't know what is WOW64,some where I read "SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64)" In my environment SQL Server 2000 version is "Microsoft SQL Server  2000 - 8.00.2282 (Intel X86)   Dec 30 2008 02:22:41   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) " is it same ?? How find out my environment is WOW or NOT. Thanks in advance          SNIVAS

migration MSDE 2000 SP3 database to SQL 2005 SP3: low performance on 2005 Express

  
I've detach MSDE 2000 SP3 database. I've attach into SQL 2005 Express SP3 and SQL 2005 Standard SP3. I've change compatibility level to 90. I've update statistics with EXEC sp_MSforeachtable @command1="UPDATE STATISTICS ? WITH FULLSCAN" The execution time of a TSQL into the same hardware (1 CPU, Quad Core) are: SQL 2005 Express SP3: 20" SQL 2005 Standard SP3: 0" The execution plan is different. Why?

Restoring Databases form SQL Server 2000 and SQL Server 2005 to SQL Server 2008 -Side by Side --he

  
Hi all I Installed SQL Server 2008 R2 in Server and I took backup of all the User databases backup from 2000 and 2005(two instance are running) Now I am doing restore the Databases,while I am restoring I am information icon in bottom of the restore window that is "The Full-Text Upgrade Option server property controls whether full-text indexes are improved,rebuild or reset" that means I have to upgrade full-text indexes or this just inforamtion.If I want find out whither Database using full-text how to check ? once I done this I have to move the users as well.Please dome body share the script you have.   Thanks in AdvanceSNIVAS

Error in SQL server 2000 after the migration (internal query processor error)

  
I just moved a couple of databases from one instance of SQL 2000 from different hardware to SQL 2000 instance of other hardware and after the move from the application side the app team gets an error -2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X. Does any one have any idea about this. I took a trace while they were testing and I found out this in the trace. exec usp_DlyPrc_LogProcessEvent '-2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X An idea or direction on this will be greatly appreciated. Thanks hash

Can I run Sql server 2000 client tools and SQL server 2005 on teh same machine.

  

Hi

Could you please advise me on this issue.

I have installed sql server 2000 client tools, and complete set up of sql server 2005 on my system.

The enterprise manager on sql 2000, crashes and and window vanishes, when ever i try to create DTS package.

They doubt its becos i am runnning both instance of sql server on the same machine- So its having some compactability issues.?

Can we run SQL server 2000, 2005 and 2008 on same machine with different instance ?

I am using windows 7 and i3 processor.

Thanks in advance.

thansks

shan


DTS on sql server 2000 and 2005

  

Here at work most of us have SQL Server 2000 and 2005 installed on our machines. When one of us creates a 2000 DTS package on our machine, it cannot be opened on on any other machine with the same setup. It will only open on the machine where it was created. We have had to use a machine that has only a 2000 installation in order to create DTS packages that can be opened on other machines.

Is there a solution to this problem?

Thanks,

MikeG


Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1

  

All,

 

In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.

 

Even when I change the parameters in start-up from configuration manager, I am getting error when starting up from cluster administrator / configuration manager.

 

But I am able to start the SQL Server successfully from command line (without any flags).

 

When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN) .

 

Please let me know incase you need any more information.


cannot restore sql 2000 database in sql server 2005 in windows 7

  

cannot restore the databse made in sql server 2000 in sql server 2005 in windows 7 with thw following error message

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'KHURANA\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

plz help me out


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

  

Hi

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.

 


SNIVAS

SQL Server 2005 - Migration from SQL Server 7

  

Hello All !

I have a SQL Server 7.0 SP4 database (10 GB) and its log from 32 bits platform. I want to migrate this db to an SQL Server 2005 x64 infrastructure.

How can I do this ? manually or by wizard ?

What are the best practices to migrate from SQL 7 to 2005 ? Tips and tircks ? Components problems (tables, views, sp, DTS, jobs , ..) ?

Have any good links on this subjects ?

 


Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

WSS 3.0 seach fail after migration from Windows Server 2003 with SQL 2000 to Windows Server 2008 wit

  

Hello we have a WSS 3.0 on a Windows Server 2003 with a single site, and we are trying to migrate it to another server with Windows Server 2008. All database are on a Microsoft SQL Server 2000.

We installed WSS 3.0 from scratch on the new server. We put the default databases on a server with Microsoft SQL Server 2008.

Then we made a backup in the production server with the following command: stsadm -o backup -url https://portal -filename musa.bak

After that we restored the backup in the new server with the following command:  stsadm -o restore -url https://uymvd18 -filename c:\sharepoint\portal-2010-10-05-21-00-06.dat -overwrite

(portal is the name of the old server and uymvd18 is the name of the new one)

Everything worked ok, but the when we try to do a search in the new se

How to migrate linked server configuration SQL 2000 and 2005?

  

I plan to migrate a SQL 2000 instance with everything in it to another SQL2000 server, and eventually in the future to SQL 2005.

I've pretty much figured out how to migrate everything execept the linked server configuration (there're many linked servers configured in the old server with different security credentials).  I'm wondering if there's way I can save the linked server configuration and restore it to the other server.

Thanks much.

Ed


what are features included/ comparision between sql server 2000, 2005 and 2008

  

Hi,

Could anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below.

sql server 2000   features |    Extra features added/supported in 2005 |   Extra features supported in 2008

Note: Please do not give any links.

 

Thanks.

 


SQL 2008 R2: Where to get all of the locks the way we used to get them in SQL server 2005 - OR 2000?

  

Hi,

In SQL server 2000 and 2005, I used to have a nice practical list of all SQL Server sessions and list of locks with useful details make troubleshooting quite easy.

In SQL Server 2008 list of locks are taken out from the “Management” section of SSMS and there is a clumsy “Activity Monitor” option which doesn’t provide information about sessions and locks in the nice way we used to have in SSMS 2005.

Using SSMS 2008, Is there any way to get the same list of locks and sessions similar to what we had in SSMS 2005?

Thank you


SQL 2008 R2: Where to get all of the locks the way we used to get them in SQL server 2005 - OR 2000?

  

Hi,

In SQL server 2000 and 2005, I used to have a nice practical list of all SQL Server sessions and list of locks with useful details make troubleshooting quite easy.

In SQL Server 2008 list of locks are taken out from the “Management” section of SSMS and there is a clumsy “Activity Monitor” option which doesn’t provide information about sessions and locks in the nice way we used to have in SSMS 2005.

Using SSMS 2008, Is there any way to get the same list of locks and sessions similar to what we had in SSMS 2005?

Thank you


Executing XML query from SQL 2005 pointing to SQL 2000 server

  
Occurs with root command.
Executed as user: DOMAIN\SERVER01. Error Code: 0  Error Source= ADODB.Command  Error Description: Item cannot be found in the collection corresponding to the requested name or ordinal.    Error on Line 18.  The step failed.
 
Executed as user: DOMAIN\SERVER01. Error Code: 0  Error Source= Microsoft OLE DB Provider for SQL Server  Error Description: Line 1: Incorrect syntax near 'ROOT'.    Error on Line 20.  The step failed.
CODE:
Dim oCmd, sSQL, oDom
   
   Set oDom = CreateObject("Microsoft.XMLDOM")
  
   Set oCmd = CreateObject("ADODB.Command")
  oCmd.ActiveConnection ="Driver={SQL Native Client};Database=Validation;Server=server1;Uid=sa;Pwd=;"
  
   sSQL = "<?xml version=""1.0"" ?>"
   sSQL = sSQL &
Categories: 
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