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 |
|
comicdust
Starting Member
2 Posts |
 Posted - 2003-06-04 : 05:25:30
|
| Hi,I'm totally new to MS SQL and has the following assignment: 1. Export databases/objects from SQL 7.0, then do a clean installation of SQL2000 (Enterprise edition) on the same W2K machine2. After the installation, import the databases/objects into SQL2000May I know what are the correct commands to export/import and what are the things that I should be aware of? Greatly appreciated all valuable assistance! |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-06-04 : 07:00:11
|
| Hi!I would recommend you to read this document:[url]http://www.microsoft.com/sql/howtobuy/howtoup.asp[/url] |
 |
|
|
comicdust
Starting Member
2 Posts |
Posted - 2003-06-11 : 21:12:24
|
| Hello, I used DTS to export/import data and select COPY tables and views from source database. The task was completed successfully but when I compared the source and destination DB, I noticed the followings:1. Database size on destination server was smaller2. Views were not imported into the destination serverCan anyone advise on this??Many thanks! |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-11 : 22:41:05
|
| Size may be different because you may/may not have had free space in the source, and you may not have transfered the indexes. Why not use backup/restore?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
SQL 7 to SQL 2000 on same machine