Sql server incompatibility

Discussion in 'Database Support' started by sanjaysk, Jan 8, 2009.

  1. sanjaysk

    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.
  2. sanjaysk

    sanjaysk Perch

    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?

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services