Sql server incompatibility

S

sanjaysk

Perch
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/medi...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.
 
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?
 
You must log in or register to reply here.
Back
Top