Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
k_sekhar_rao
Starting Member
8 Posts |
 Posted - 2003-04-16 : 04:32:05
|
| Hi all,I am doing data transfer (full database) from 6.5 to 2000.Is it enough if i simply import data or i need to upgrade the database from 6.5 to 2000 in order to have all the settings in 6.5 to be migrated to 2000 server.Thanks in advance,sekhar |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-16 : 05:29:17
|
| You can upgrade the database in which case it will set the 2000 database to be as close to the 6.5 one as possible.Or you can create a 2000 database - set it to 6.5 compatibility mode and set any other setting you wish, then transfer the objetcs.The latter will give you a method you can repeat easily but the former will give microsofts idea of what it should be.You should do the upgrade to see what you get and to see if it gives any warnings.I would then go with the manual transfer - you will want to do a lot of testing on the result whatever you do.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
data transfer