Moving to a new hosting provider...
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15089
Printed Date: 13 April 2026 at 3:36am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Moving to a new hosting provider...
Posted By: iSec
Subject: Moving to a new hosting provider...
Date Posted: 15 May 2005 at 4:27am
|
I'm about to change my hosting but i am having a hard time with exporting my MS SQL d/b ...I've tried many tools but they were all complicated and didn't help me much... Can anyone help? thanks. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 15 May 2005 at 5:09am
|
I usually use the export and import tools in Enterprise Manager to
download the database to my own PC (running MS SQL Server 2000) before
uploading to the new hosts server.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: iSec
Date Posted: 15 May 2005 at 5:14am
|
How can I get the MS SQL Enterprise Manager tool? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 15 May 2005 at 5:24am
|
It comes with MS SQL Server 2000, if you follow my suggestion then you need to install MS SQL Server anyway.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: iSec
Date Posted: 15 May 2005 at 5:31am
|
Is MS SQL Server available to download for free and where? Thanks for your help borg. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 15 May 2005 at 8:58am
|
Only the desktop version that doesn't have the Enterprise Manager with it.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Gullanian
Date Posted: 15 May 2005 at 9:12am
| The trial version of SQL Server from the Microsoft site has a version with it bundled in for free. |
Posted By: dpyers
Date Posted: 15 May 2005 at 1:09pm
|
The developer version of MS SQL is arounf $40 US. Comes with EM, Books Online complete MS SQL documentation, and a distribution license.
The trial version of MS SQL expires after 90 days but EM doesn't expire - not licensed after 90 days though. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: iSec
Date Posted: 15 May 2005 at 7:12pm
|
Thank you so much guys... I downloaded the trial version, it's awesome!
One thing that my current hosting provider should know...That I am able to view and change all other databases they have installed
 if i was someone that's malicious I'd have deleted all the databases on their server... Once I logged in using my db username/passsword I saw all the databases that hosting server has, here's a screenshot: ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: dj air
Date Posted: 15 May 2005 at 7:22pm
|
with MSSQL server and other servers some hosts allow the viewing of the
names(only). you can't view the actual content etc of the databases. we used to do it that way but now to speed the database download up we have reduced it to the default databases and the ones that are help to the login username |
Posted By: dpyers
Date Posted: 15 May 2005 at 8:37pm
Ask your host to investigate sp_MSdbuseraccess SP to get it setup the way dj air has it. Also eliminates the need for EM to load all the bn names so it's active a lot faster. -------------
Lead me not into temptation... I know the short cut, follow me. |
dj air wrote:Posted By: iSec
Date Posted: 17 May 2005 at 12:26am
|
Moveing databases does not work. Is there a procedure to do this? Do you the my_SQL_Server_Setup.asp first to create the tables and relationship and the procedures? If so how do you then upload your data to the newly created tables. I keep getting the FOREGIN KEY ALREADY EXIST when used with import/export tool of SQL server.
------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: dj air
Date Posted: 17 May 2005 at 10:57am
|
it is possible to move MS SQL databases i have up sized access databases from access 7.9 to SQL 7.9, also i have tranferred 1 MS SQL database into IportalX for a client, without any major actions. just import data. i found that if you do the tables one by one its ok iusing DTS - move author table - move category table - move forum table - move topics table - move threads then move the other tables make sure the deleivery /destination table is amending or deleting existing records and that the owner of the table is correct ussually by default dbo once i made sure the threads table is set to dbo owner it went ok. all the otheres went 100% fine. |
Posted By: iSec
Date Posted: 17 May 2005 at 4:54pm
|
I have successfully moved it but I got a new problem Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'Last_visit', table 'iraqvoi_forum.dbo.tblAuthor'; column does not allow nulls. INSERT fails. /forum/register.asp, line 969 ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
I tried to register as a new user and when I fill the registeration form and click register I get the following:Posted By: iSec
Date Posted: 17 May 2005 at 4:57pm
|
Also, when posting a reply to an existing topic I get the following:
ADODB.Recordset error '800a0cb3' Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /forum/post_message.asp, line 746 ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: dj air
Date Posted: 17 May 2005 at 5:24pm
|
the first error means that you didn't tranfer correctly.. you didn't send the default values for the fields. you need to set the default values for the tables now. im not sure on the fiest one but think it may be related. |
Posted By: iSec
Date Posted: 18 May 2005 at 6:55am
How do I do that? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: dj air
Date Posted: 18 May 2005 at 7:20am
|
you need to open the table in Enterprise manager .. in design view and set the default values.. then update it.. you should have moved the table from old DB to the new keeping it in tacked really. without creation of the table.. |
Posted By: iSec
Date Posted: 23 May 2005 at 11:30pm
|
I still can't do it! I don't want to start all over... this has been done in the past and I lost about 900 members at that time... I'm really struggling now. dj air, can you help me further and try to do it yourself if i give you the hostname, db name, and password, pleaseeeee? I would really appreciate that. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: dj air
Date Posted: 24 May 2005 at 6:41am
|
i'm feeling generous today. either send me the details via PM and how big is the access db you have. or send me a IM through MSN or AIM , let me know if its AIM as i dont have it on all the time. |
Posted By: iSec
Date Posted: 24 May 2005 at 9:05am
|
Ok mate, I will PM you with the db login info as well as my MSN messenger email. Thanks. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: iSec
Date Posted: 25 May 2005 at 7:38am
|
Thanks to dj air for helping me, i would not have got my forum back without his aid. thanks again so much. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: dj air
Date Posted: 25 May 2005 at 7:44am
|
no problem. if yopu find any errors from the tranfer let me know |