conversion tools for sql7 databases

is there any tool / utility , online service / websites that will help me convert a MSSQL 7 database to be compatible to MSSQL2k ?
i have enterprise manager for 7 , but when i try to connect to server which has sql2000 ... i cant .
thanx .You need to uninstall Client Tools for SQL 7.0 and install Client Tools for 2K.

Conversion Tools

Are there any tools to convert Crystal Reports to SSRS out there besides KTL's Crystal Converter?

http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx|||

I went through that list and most of those are services. I am looking for tools like Crystal Converter.|||

To my understanding, Crystal (Business Objects) disapprove commercial converters. For this reason, most vendors offer this as a service.

|||

Thank you for your help.

Conversion from Sybase to SQL Server 2000

Hi,
Could anyone refer me any kind of tools or process to convert from SYBASE to SQL SERVER 2000.
My complany is trying to migrate from SYBASE to SQL SERVER 2000.
Any help is greately appreciated!
Thanks.While it isn't exactly a "tool" per se, the section on migrating from Sybase to SQL-2000 in the SQL Server Resource Kit is excellent. Microsoft provides a number of executables on the CD that help with the migration process too.

-PatP|||If you would like to convert the schema, I would recommend ErWin. We did the same conversion about two years ago, and this tool was a big help. It's also nice to have for ongoing schema changes. Though, it's not cheap.

As far as the stored procedures and such, we just did ours manually. There aren't too many syntax changes needed, so it was fairly easy.

Roby2222

Continued issues with SQL2K5 - SP2

I continue to have issues with SP-2 for SQL 2005 suite. It has now gotten so bad, I have multiple installations, including the TOOLS ONLY on my laptop failing, that I am going to stop ALL future installations of SP-2. The COM+ failures have not been resolved that I can determine. I have tried uninstalling, I have tried SP-1 before SP-2, every combination one can find. HELP.

Time: 05/07/2007 13:24:05.631
KB Number: KB921896
Machine: GA029-MDGRAVES
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
MSXML 6.0 Parser ENU 6.00.3883.8 x86
Backward Compatibility ENU 8.05.1054 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
-
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and configure assemblies c:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information. (Exception from HRESULT: 0x8004D027)
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3883
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29549

Here's an external blog that discusses the workaround for the issue:

http://geekswithblogs.net/waterbaby/archive/2006/08/03/87048.aspx

Thanks,
Sam Lester (MSFT)

|||The link to XP fix was great. Thanks.

Consolidating Profiler, DTA into Mgmt Studio

Would it be possible to create "light verisons" of these external tools and integrate them into Mgmt Studio as another window in the IDE? Maybe have a "Quick Trace" window etc...

Thanks,

Derek

It is something that has been discussed yes, pelase use the product feedback centre to log it or vote for a similar one.|||

Product Suggestion Link...

http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=b8057e3f-808f-4d05-a8b9-c1b830cfd648