| Author |
Topic |
|
malletts
Starting Member
16 Posts |
 Posted - 2004-03-15 : 16:47:37
|
| Hi,Has anyone been able to get DTs running between SQL 6.5 to SQL 7.0 actually working? When I try to DTS, I get an error prompting me to run instcat.sql - when I run these on both the 6.5 and 7.0 servers, a host of other problems appear such as 'Schema Rowsets' and system stored proecedures missingSome stored procedures created by the instcat script also don't appear to be createdHelp!!!!!!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-15 : 16:51:33
|
| Did you install the latest service packs for each of those products on the database servers? Did you also install these service packs on the client machines?Tara |
 |
|
|
malletts
Starting Member
16 Posts |
Posted - 2004-03-19 : 13:02:47
|
| Hi,thx for getting bacl. Have tried installing the latest SP for 6.5 (SP 5) but problems with NT machine running this (won't even let me install Office). Have reverted to exporting to Access from SQL 6.5 and then importing from Access into SQL 7 (with numerous date problems so loads of fun!)STephen |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-03-19 : 17:20:56
|
| I would have used "Generate SQL Scripts" and BCP, personally. What you did didn't bring over any constraints, indexes, data types, etc... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-19 : 17:26:00
|
| Are you just upgrading from 6.5 to 7.0? If so, why aren't you using the upgrade wizard?Tara |
|
|
|
malletts
Starting Member
16 Posts |
Posted - 2004-03-22 : 09:21:20
|
| Yes, I am just migrating from 6.5 to 7.0. Problem is that the server that runs 6.5 is being thrown out so all databases are being migrated to another existing server which is running 7.0. Scripting is fine in terms of recreating db ojects, constraints etc on 7 - the only problem is the data and known issues exporting/importing to Access from SQL ServerThanks for your help - im slowly getting there! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-22 : 12:30:40
|
| But you can still use the upgrade wizard. It's purpose is exactly for this: to upgrade 6.5 to 7.0 or 2000. The upgrade wizard can be used for a one server or two server method. Your scenario is called the two server method.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-03-22 : 12:34:37
|
| I would script the database and use bcp....but that's just me...Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-22 : 12:36:49
|
| That's essentially what the wizard does. I don't normally recommend wizards, but for the upgrade from 6.5, I do.Tara |
|
|
|
|
SQL 6.5 migrate to SQL Server 7.0