Print Page | Close Window

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 Confused 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
Originally posted by dj air dj air wrote:

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


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 Ouch I tried to register as a new user and when I fill the registeration form and click register I get the following:

 

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


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
Originally posted by dj air dj air wrote:

you need to set the default values for the tables now.
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. Clap



-------------
"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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net