<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[IMPORTANT INFORMATION — SQL 2000 to  SQL 2005 Migration / Network questions]]></title>
		<link>https://forums.nbn.org.uk/viewtopic.php?id=564</link>
		<atom:link href="https://forums.nbn.org.uk/extern.php?action=feed&amp;tid=564&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in SQL 2000 to  SQL 2005 Migration / Network questions.]]></description>
		<lastBuildDate>Tue, 26 Feb 2008 10:01:26 +0000</lastBuildDate>
		<generator>PunBB 1.4.6</generator>
		<item>
			<title><![CDATA[Re: SQL 2000 to  SQL 2005 Migration / Network questions]]></title>
			<link>https://forums.nbn.org.uk/viewtopic.php?pid=2566#p2566</link>
			<description><![CDATA[<p>Migrating from SQL Server 2000 to SQL Server 2005 is similar to migrating from MSDE to SQL Server. This is covered in the Network Installation Guide (page 10 in v5.1).&nbsp; Hopefully there is enough information there to do your migration. The default database and log file names are NBNData_Data.MDF and NBNData_log.LDF.</p>]]></description>
			<author><![CDATA[null@example.com (sallyrankin)]]></author>
			<pubDate>Tue, 26 Feb 2008 10:01:26 +0000</pubDate>
			<guid>https://forums.nbn.org.uk/viewtopic.php?pid=2566#p2566</guid>
		</item>
		<item>
			<title><![CDATA[Re: SQL 2000 to  SQL 2005 Migration / Network questions]]></title>
			<link>https://forums.nbn.org.uk/viewtopic.php?pid=2532#p2532</link>
			<description><![CDATA[<p>Hi All,</p><p>We currently have a Recorder v6.10 database running under SQL 2000 server and I have been asked to migrate the data across to our new &#039;virtual&#039; SQL 2005 Standard Server environment (VMware based) I don&#039;t for see any major problems in doing this as I intend to keep the sql compatability mode set at &#039;80&#039;, as I understand SQL 2005 Is not yet fully supported?&nbsp; </p><p>Question1:<br />Is there any documentation out there that can assist me with the move from one SQL Server to another (or is it just a case of backup/restore or attach/detach?) are there any guidelines I should be following?</p><p>Question2:<br />Once the database has been moved to the new environment a couple of external users will require access to it across a 10MBit wan link, bearing in mind our database is quite large what sort of performance could we expect?</p><p>Question3:<br />Are there any specific ports that need to be opened through our firewall to allow these external users access to Recorder apart from the obvious SQL ports? </p><p>Many Thanks,<br />Mark</p>]]></description>
			<author><![CDATA[null@example.com (Markb)]]></author>
			<pubDate>Tue, 19 Feb 2008 12:17:54 +0000</pubDate>
			<guid>https://forums.nbn.org.uk/viewtopic.php?pid=2532#p2532</guid>
		</item>
	</channel>
</rss>
