Quote:
Originally Posted by TrevorL
1. "Connect the SQL database remotely and create all the tables in it." - assuming you mean do this with Management Studio or similar in place of the Plesk WebAdmin route - I'll try this and report back.
|
I've just tried this (and I remember now I did try it over the weekend). I use SQL Server Management Studio Express and connect to mysql.preservedtanks.com and login in to my database using my SQL Server user id and password (i.e. the same as I used in Plesk to create the database). This shows me a list of databases called DURHAM\Databases; there are about a 100 shown so I imagine they are all the client databases on our shared server - but I only have permission to see the details in my databases. Within my ones I can see the available tables etc. However, if I Execute a query against my database to create new tables it just generates errors and no new tables are created.
Edit: I've looked into this in some more detail - some simple commands (e.g. CREATE TABLE) execute successfully, but the full script required to recreate my databases fails. I'm thinking it may be a SQL Server version problem. I'm using SQL Server 2005 Express at my end.
Could it be that SQL Server 2000 or some other version is running on the server?
It's looking like this 'Method 1.' could work, but I'd still appreciate some feedback on the questions in my post above.