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.
| Author |
Topic |
|
amjad171
Starting Member
15 Posts |
 Posted - 2008-09-23 : 05:11:57
|
| Hello,I'm wondering if anyone can help with a query I have. Locally I have SQL Server 2005, but my hosting provider has SQL Server 2000. The problem is the script that is generated when I use SQL Server database publishing Wizard to trasnfer the database to the hosting provider generates lots of errors, I'm certain this is to do with the fact that i'm going from 2005 to 2000, does anyone know of any tools or applications out there that will convert this sql file into a 2000 compatible file?Many thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-23 : 05:15:55
|
| whats the compataibility level of 2005 db? you can set it to 80 if you want it to be consistent with sql 2000 db. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-23 : 05:17:38
|
| Get a new hosting provider. There a lots out there and reliable ones as well.Bear in mind MS SQL 2008 is out. Why go backwards ???http://support.microsoft.com/lifecycle/?p1=2852We are migrating our primary db to 2008 this wkend. |
|
|
|
amjad171
Starting Member
15 Posts |
Posted - 2008-09-23 : 06:33:40
|
| I agree with you but unfortunately we wouldn't be able to change over, the hosting provider did say by the end of this year they will be on 2005, but I wouldn't hold my breath. There is an option within SQL Server publishing Wizard that allows you to convert for 2000, this seems to have worked. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-23 : 06:50:32
|
| Its a lot of work upgrading and downgrading. And you miss out in many new features supported in 2005 and now 2008. - Also, when will they support 2008 ?2000 has a few shortcomings which wont work for us at this point in time, security, varchar(max), .net features, ADO.NET etc |
|
|
|
amjad171
Starting Member
15 Posts |
Posted - 2008-09-23 : 08:33:47
|
| varchar(max) is the one I got caught out with, 2000 wouldn't support it. Considering they haven't upgraded to 2005, I would say atleast a few years before they get to 2008, lets hope not though. the database won't have highly confidential information and 2000 should be fine to store the data. |
|
|
|
|
|
|
|
|
Transferring from SQL 2005 to SQL 2000