mlg101
asked on
Web host problem with attaching MS Sql database
My webhost is impossible! They do not seem to know how to attach my MS Sql databse files to their shared sql server 2005. They tell me I can use management studio express, which i have tried, but do not know how. It seems they should be able to do it no problem. They have a webadmin on my website admin page, but it does not have a function for me to import my databse files I have created on VWD express. Do you know how to do it with management studio express or another way? Thank you
ASKER
I have sql server 2005 express, the copy database wizard says that I have to have sql server 2005. anything else? I am going from express on my computer, to regular 2005 on the web server
I didn't understend your response.
"the copy database wizard says that I have to have sql server 2005."
Do you mean that you cannot use copy database wizard? Is there any error?
You can also backup and restore database.
This should help you:
http://technet.microsoft.com/en-us/library/ms189624.aspx
"the copy database wizard says that I have to have sql server 2005."
Do you mean that you cannot use copy database wizard? Is there any error?
You can also backup and restore database.
This should help you:
http://technet.microsoft.com/en-us/library/ms189624.aspx
Also if you want to create only tables without data you can generet script:
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/
ASKER
i will check out those links. all i was saying was that 2005 express cant copy directly to 2005, from what i read.
Ok. So try to download 2005 developer edition (it's free for development and it has all future as standard or enterprise edition)
But you should be able to do this using backup and restore.
Best Regards
But you should be able to do this using backup and restore.
Best Regards
I'm happy to stand corrected on this remark but I do not believe that Developer edition is free. It is nearly free (about £40 sterling), only express edition is free.
Ohh
I didnt know that :) Thanks :)
I didnt know that :) Thanks :)
ASKER
what exact program are we talking about? sql server 2005 developer edition? or visual web developer 2005 developer edition? or visual studio developer edition? i'm not sure.
ASKER
Minimum system requirements for sql server 2005 developer edition requires Windows Server 2003, which I dont have. I just have windows XP
ASKER
maybe you could tell me if it would work on my system without windows server 2003
http://www.microsoft.com/sql/editions/developer/sysreqs.mspx
http://www.microsoft.com/sql/editions/developer/sysreqs.mspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i just found out my webhost does not allow me access to their sql server, so I cannot backup and restore. They have to do it, but they tell me different things every time. I'm just going to get another web host. This is rediculous!!!
:D
<lol>
"webhost does not allow me access to their sql server" - this is a good thing :)
"They have to do it, but they tell me different things every time" - yes they should.
Or you can generate script and run It on server.
Good Luck
FooKy
<lol>
"webhost does not allow me access to their sql server" - this is a good thing :)
"They have to do it, but they tell me different things every time" - yes they should.
Or you can generate script and run It on server.
Good Luck
FooKy
Select your local database as source and webhost database as destination
then copy everything.
I'm not sure if express edition has such futures. If not then download nad install developer edition atach your database and then use copy database wizard.
BTW
You can not atach database using management studio because of lack of privileges.
Best Regards
FooKy