Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Convert SQL 2K5 DB objects to SQL 2K?

Author  Topic 

sqlontherun101
Starting Member

16 Posts

Posted - 2009-10-17 : 13:08:19
HI,

I need to use crystal reports with SQL server, unfortunately SQL 2005 express doesnt support Crystal reports. Therefore i want to convert my SQL 2005 Express DB objects to SQL 2000 DB objects, i dont want to redesign the whole tables and database in SQL 2000, therefore is there a convertor utiility available for free?

I use SQL 2000 Developer version with SQL 2K5 Express

TY

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2009-10-18 : 13:10:04
What do you mean Crystal Reports does not work with SQL Server 2005 Express? Why would you decide to downgrade to an unsupported platform instead of using the most current version?

Really, you should be moving forward with SQL Server 2008 instead of 2005 - and Crystal Reports really doesn't care what version the database is that it is going to connect to. You use an ODBC/OLEDB connections from Crystal to the database and the Express versions support that with no problem.

Most likely, when you installed the Express edition you did not configure TCP/IP and that is why you are having problems.
Go to Top of Page
   

- Advertisement -