Sql server incompatibility

Customer Support Database Support
1

In a recent thread, I was advised to use EMS Sql Manager freeware to create tables, etc. At that time, it worked ok because the table might have been simpler.

Today, when I exported scripts in it for creating tables to duplicate my local tables, it generated sql server 2005 scripts which gave all sorts of syntax error on my jodohost server which I think is sql server 2000. I am getting errors similar to the one mentioned in this article:

http://thewebjedi.com/cs/blogs/meditations/archive/2007/09/26/sql-server-2005-syntax-incompatible-with-sql-server-2000.aspx

Questions:

  1. Is it possible to migrate my databases to sql server 2005 so that I use the latest?
  2. I can’t find an option in EMS tool to generte scripts for Sql server 2000?

I have already submitted a ticket but want to get tips from here if any.

2

OK, I was able to generate a proper 2000 compatible script from Sql Server Management
Express. But I can’t find that option in the EMS tool anywhere.

Also, my first question remains: how can I use sql server 2005 on my jodohost account (windows shared hosting)? Can a move be made?