Need url on good kb or article on converting sql 2000 to sql 2005 (full version not express)
View Complete Post
i would like to ask what the difference between sql server 2000 and 2005
I was hoping I wouldn't be another poster with performance issues after migrating to SQl 2005 from SQL 2000 but here I am.
I am in the process of testing out our databases on Sql Server 2005 for migration from SQL Server 2000 and there are certain portions of code that have been affected negatively. I have read thru many of the posts here and have tried out most of the recommendations. I will start out with things I've done and then provide the actual SQL.
1) I have rebuilt all indexes ( using the DBCC REINDEX using the table option).
2) Updated the db engine to latest hot fix (build 3239) that addresses speed related fixes.
3) I also ran sp_createstats using the 'fullscan' option to create stats on all columns of all tables (minus indexed columns)
4) Since nothing seemed to work, I even ran UPDATE STATICS with FULL SCAN on all tables even though I did not need it as the REBUILD woudl have created stats. But I was willing to try anything.
I have confirmed that the execution plans are different even though the data on both sql 2000 and sql 2005 are identical (i put a copy on 2005). The plans themselves are huge as the queries are huge. Here is the query.
i am upgrading 2000 olap cube to 2005. i built an ssas project and deploy to the server.
the 2000 olap cube store it's data in partitions - one for each month.
the face table delete it's data and store data for only the last 13 month so basically most of the data
is store onle in the 2000 cube.
while upgrading the cube and processed it , a lot of information had lost.
i know that i cant restore the fact from the partiotn data but is there a way to copy the partition has is
from olap 2000 to 2005?
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.
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?
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
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
plz help me out
I have been asked to move one of our companies datawarehouses from SQL Server 2000 to 2005. I have made a backup of the 2000 datawarehouse and the .bak file is almost 14Gig. I have also saved the create scripts. What would be the best way to do this migration?
Do I create the tables on 2005 using the scripts i generated and then import the backed up data? if so what is the best way to compress this file since moving 13gig from 1 side of the world to the other on our network will be VERY, VERY slow. Or is there
another better more efficient way?
If I create a table by using a following simple statement:
create table manojtemp (
sn int identity(1,1) primary key not null,
We recently upgraded a report server and corresponding reports from SQL Server 2000 (reports 2003) to SQL Server 2005. After upgrade one of our reports which use two subreport is very very slow.
The sp's used for these all these reports are fast. All the sp's together takes about 40 secs.
Both in the BIDS environment as well as the report site the report is very slow.
We are using a database in which data is inserted through replicatoin. In all our sp's we have given 'with nolock' along with the table names.
Can anyone please help me here?
Request to provide the tips and details for migrating data from SQL 2000 to 2005.
Thanks in advance
will i be able to install sql server 2000 on a machine where there is 2005 installed? basically i am trying to downgrade!!