Web Wiz Support and Community Forums : Moving MSSQL data to a new server https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 06:14:31 +0000 Fri, 14 Apr 2006 18:44:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18634 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Moving MSSQL data to a new server : The only option I have is restoring...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post104275.html#104275 Author: wistex
Subject: 18634
Posted: 14 April 2006 at 6:44pm

The only option I have is restoring the database.  The host I am temporarily using (after having major problems with our now former host) doesn't even allow us Enterprise Manager access to the database!  I can, however, make a backup file and download that.

Thanks for letting me know about the backup/restore method.  You are saving me hundreds of dollars in hosting fees and helping us with the performance issues we are having due to using a shared MS SQL Server.
]]> Fri, 14 Apr 2006 18:44:02 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post104275.html#104275 <![CDATA[Moving MSSQL data to a new server : 1. Yes you can, I have SQL Express,...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101754.html#101754 Author: WebWiz-Bruce
Subject: 18634
Posted: 20 March 2006 at 10:59am

1. Yes you can, I have SQL Express, SQL 2005 Developer Edition, and SQL 2000 Developer Edition all install on this computer at the moment, just installed under different instance names.

2. Enterprise Manager and the full SQL Server Management studio both come with DTS import export tools for moving SQL Databases, the only version that is not compatible with these tools in SQL 2005 Express which is limited. But you can detach and attach databases in SQL Express 2005 which would help in moving databases.
]]> Mon, 20 Mar 2006 10:59:18 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101754.html#101754 <![CDATA[Moving MSSQL data to a new server : This is maddening... SO there...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101734.html#101734 Author: Ozoyo
Subject: 18634
Posted: 20 March 2006 at 9:18am

This is maddening...

SO there is no import tool in SQL 2005 Shocked.

I have installed 2005 express locally on the server but I can't import my SQL 2000 DB which is on a distant server.
I have found a way to import a DB from MSDE to SQL 2005 (not testedthough). But my main issue is that I can't install MSDE on my server(something about SA password), I have tried to change the password astold on the Microsoft site but no success... Cry.

I have few questions:

1. Can you have SQL 2005 and MSDE on the same server? Is that why I have the password issue?

2. Does MSDE have an import wizzard that I can use to import my DB from the distant server?

Thanks



]]> Mon, 20 Mar 2006 09:18:12 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101734.html#101734 <![CDATA[Moving MSSQL data to a new server : Not in a standard installation.It...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101545.html#101545 Author: WebWiz-Bruce
Subject: 18634
Posted: 17 March 2006 at 11:54am

Not in a standard installation.

It sounds like someone may have modified the code, have a look in both the common.asp files as this is where the connection string is used to connect to the database, someone may have modified the code in these files.
]]> Fri, 17 Mar 2006 11:54:00 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101545.html#101545 <![CDATA[Moving MSSQL data to a new server : Talk about weird? I&#039;ve looked...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101521.html#101521 Author: Shaun
Subject: 18634
Posted: 17 March 2006 at 12:59am

Talk about weird?

I've looked at that file and in that exact location etc.

BUT

The details for our current MSSQL database are incorrect.

It's been filled in with something different, definately not the MSSQL DB I've been using.

Anywhere else I should be looking?]]> Fri, 17 Mar 2006 00:59:45 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101521.html#101521 <![CDATA[Moving MSSQL data to a new server : I do plan on having support for...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101474.html#101474 Author: WebWiz-Bruce
Subject: 18634
Posted: 16 March 2006 at 1:39pm

I do plan on having support for Windows Authentication in version 8 for db versions, but as I want to get version 8 out as soon as possible it will have to wait now till version 8.1]]> Thu, 16 Mar 2006 13:39:09 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101474.html#101474 <![CDATA[Moving MSSQL data to a new server : Sorry I missed that as well. Change...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101472.html#101472 Author: rx7tt
Subject: 18634
Posted: 16 March 2006 at 1:25pm

Sorry I missed that as well. Change 
strSQLServerName = "" 'Holds the name of the SQL Server
to (local) in the file boRg stated.

Another cool thing that I'm not sure is possible with MSDE but works with SQL express is using Windows authentication for the forum instead of sql server authentication. Might be something to add to V8, as it would only add one line.

-Scott]]> Thu, 16 Mar 2006 13:25:33 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101472.html#101472 <![CDATA[Moving MSSQL data to a new server : As far as I can recall, in version...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101458.html#101458 Author: WebWiz-Bruce
Subject: 18634
Posted: 16 March 2006 at 11:58am

As far as I can recall, in version 7.x it should be 'admin/SQL_server_connection.asp']]> Thu, 16 Mar 2006 11:58:27 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101458.html#101458 <![CDATA[Moving MSSQL data to a new server : Many thanks Scott (top car, top...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101405.html#101405 Author: Shaun
Subject: 18634
Posted: 15 March 2006 at 10:59pm

Many thanks Scott (top car, top help)!

I'll probably get back in touch at some point LOL.

Just one final question, which I've asked a few times but haven't had the answer as yet.

Which file do I need to change (and how), to point the forum to the new SQL database and location etc?

Cheers again,
Shaun]]> Wed, 15 Mar 2006 22:59:35 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101405.html#101405 <![CDATA[Moving MSSQL data to a new server : Thanks scott, this is also what...]]> https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101319.html#101319 Author: WebWiz-Bruce
Subject: 18634
Posted: 15 March 2006 at 10:14am

Thanks scott, this is also what I was looking for, as from what I read from Microsoft the DTS tools don't work in SQL 2005 Express. Now I know how to do this I will probably be upgrading to SQL 2005 Express very soon.]]> Wed, 15 Mar 2006 10:14:58 +0000 https://forums.webwiz.net/moving-mssql-data-to-a-new-server_topic18634_post101319.html#101319