Need a leg up on migrating from SQL 7 to SQL 2005 (HOW TO?)

I have a SQL7 server that runs one database for our company. The rest of the datastore is on a SQL2005 server. How best can I transfer the SQL7 database to SQL2005??

There are a variety of ways, but the most straightforward is to simply back up the SQL 7.0 database, and restore it onto a SQL 2005 instance...

--
Adam Machanic
Pro SQL Server 2005, available now
http://www..apress.com/book/bookDisplay.html?bID=457
--

|||I have tried to do that, but the SQL 2005 server balks at the backup. Is there anything special one has to do in order to get the backup to restore properly?|||?

Is your SQL 7 server patched to the last SP (4, if I recall properly)? I believe that is a prerequisite. If it is, what is the exact error you're getting?

--
Adam Machanic
Pro SQL Server 2005, available now
http://www..apress.com/book/bookDisplay.html?bID=457
--

|||

I applied SP3 and SP4. Afterwards, I was able to produce a useable backup that I was able to restore to SQL 2005

Thanks for your help

Need a detail section which runs horizontally

I'm make a report which has a detail section that runs left to right (records 1 to 3) then to the next line down etc... so line 2 will have records 4 to 5.

Traditionally detail sections run top to bottom and this is very easy to design but I'm at a complete loss as to how to do it with the records running left to right as well. Perhaps you'd need to somehow manual increment the record pointer ??

Crystal reports v9

Thanks for the helpDoes CR9 have a 'Format with multiple columns' checkbox in the section expert?
If so, check it and then choose the 'Layout' tab that appears. You'll then need to experiment with the values in that tab - see help on 'Layout tab (Section Expert)'.

Need "commercial grade" FileWatcher task

Does anyone know of such a task than runs under both x86 and x64? (I know a FileWatcher add-in but it was built using Beta verisons of VS.NET)

TIA,

barkingdog

I would suggest using the WMI Event Watcher task - see http://msdn2.microsoft.com/en-us/library/ms141130(SQL.90).aspx

Donald