| Author |
 Topic Search  Topic Options
|
jp05 
Newbie
Joined: 14 December 2007
Status: Offline
Points: 7
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 14 December 2007 at 5:10pm |
|
I need to back track a wee bit. I had nothing to do with the creation of this site. I'm just trying to facilitate getting it up and running with a new host. I had originally assumed the database was hosted at the same place the site resided. I spoke with that provider, and he told me that was not the case. So, I was then under the assumption that your company was housing that... now I'm thinking that might be incorrect... I'm not a programmer-type, so this is all a little out of my realm of expertise... How do I find the stinkin' database?? ("ask the client" would seem like an obvious answer to that, but I can all but guarantee that that will get me nowhere.)
thanks!
|
 |
jp05
Newbie
Joined: 14 December 2007
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 5:22pm |
|
for the record, the GoDaddy issue is settled. I'll suggest a different host.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 5:33pm |
|
You can look in the database connection file. This should give you a good idea.
The file is at database/database_connection.asp and in this file you should find the SQL Server connection, hopefully it would be a URL such as sql.webhost.com if it's an IP address it maybe a bit more difficult to track down, but can be done.
However, SQL Server is not a file that you download, you would need to use tools to migrate the database from the previous host, which isn't always simple as newer tools in Microsofts Management Studio for SQL Server don't like to transfer default values and indexes.
The last SQL Server database I transferred took over 3 hours to get it across from SQL Server 2000 to our own SQL Server 2005, but managed it in the end.
|
|
|
|
jp05
Newbie
Joined: 14 December 2007
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 5:46pm |
|
Very helpful. Sounds like I'll have to bring in someone with a bit more experience with this sort of thing. Have a wonderful evening.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 6:58pm |
|
If you can track down where the SQL Server database is, you hopefully should be able to ask the provider for a backup of the database, this can then be used by your new host to restore the database on their servers.
It takes a bit of co-operation from both providers, but may make it simpler if you can get them both to play ball.
|
|
|
|
