Import data from SQL Server

Hi,
I imported database OldData from SQL Server 6.5 to NewData in SQL Server
2000, and the database can be imported. However, there's no Index in any
table in the NewData.
Would anyone tell me how to fix this problem?
Thanks.
JasonHi,
How did you moved the database from SQL 6.5 to SQL 2000? . If you use
"upgrade Wizard" that will automatically copy all objects from SQL 6.5 to
SQL 2000.
If you use DTS or BCP then only the table and data will be transferred to
SQL 2000. You may need to create all the other objects manually.
Thanks
Hari
MCDBA
"Jason" <JASON88@.seed.net.tw> wrote in message
news:c6a41m$oo2$1@.news.seed.net.tw...
> Hi,
> I imported database OldData from SQL Server 6.5 to NewData in SQL Server
> 2000, and the database can be imported. However, there's no Index in any
> table in the NewData.
> Would anyone tell me how to fix this problem?
> Thanks.
> Jason
>|||Thanks Hari.
I used the upgrade wizard tried to upgrade from 6.5 to 2000, but it show an
error message with SQL-DMO, and the 6.5 has to migrate to 7.0 first.
Is there anyway to upgrade from 6.5 to 2000 without upgrading to 7.0 first?
Thanks for help.
Jason
"Hari" <hari_prasad_k@.hotmail.com> bl
news:OQ93AfOKEHA.2776@.TK2MSFTNGP12.phx.gbl g...
> Hi,
> How did you moved the database from SQL 6.5 to SQL 2000? . If you use
> "upgrade Wizard" that will automatically copy all objects from SQL 6.5 to
> SQL 2000.
> If you use DTS or BCP then only the table and data will be transferred to
> SQL 2000. You may need to create all the other objects manually.
> Thanks
> Hari
> MCDBA
>
> "Jason" <JASON88@.seed.net.tw> wrote in message
> news:c6a41m$oo2$1@.news.seed.net.tw...
any[vbcol=seagreen]
>|||Hi Jason,
Using the SQL Server Upgrade wizard you can upgrade directly from SQL 6.5 to
SQL 2000. The steps are detailed below:-
1. Ensure that SQL 6.5 is running and all the databases are up (Run DBCC and
check the databaseconsistency)
2. Update the SQL 6.5 service pack to latest , probably sp5a
3. Install SQL 2000 and Sp3a for sql 2000
4. In SQL 2000 program groups there will be upgrade wizard, it will
automatically sence SQL 6.5 and upgrade
the sql 6.5 databases to SQL 2000
5. This upgrade wizrd leave the SQL 6.5 databases safe
6. There will be switch option which can be used to switch between sql 2000
and SQL 6.5
Look into SQL 2000 books online, this has got the detailed steps to perfoerm
upgrade between SQL 6.5 to SQL 2000 with
a. all the prerequisites before upgrade
b. Upgrade steps
c. After Upgrade
(Do not use DTS / BCP... This will take long time)
Thanks
Hari
MCDBA
"Jason" <JASON88@.seed.net.tw> wrote in message
news:c6alu7$qt$1@.news.seed.net.tw...
> Thanks Hari.
> I used the upgrade wizard tried to upgrade from 6.5 to 2000, but it show
an
> error message with SQL-DMO, and the 6.5 has to migrate to 7.0 first.
> Is there anyway to upgrade from 6.5 to 2000 without upgrading to 7.0
first?
> Thanks for help.
> Jason
> "Hari" <hari_prasad_k@.hotmail.com> bl
> news:OQ93AfOKEHA.2776@.TK2MSFTNGP12.phx.gbl g...
to[vbcol=seagreen]
to[vbcol=seagreen]
Server[vbcol=seagreen]
> any
>