Import index and constain

Dear
I export the database table,SP,view,use..etc to script
file. After i run the script to another server to rebuild
the database. Only the table(index and constain) can't
import to new database but i have choice the option(index
and constain) when i export the database to script. What
is ths problem?
Many Thanks
JohnJohn
How did you export your objects?
Try using DTS , there is an optino "Transfer Objects" so you will find that
you can export indexes and keys.
"John" <anonymous@.discussions.microsoft.com> wrote in message
news:066301c3c476$0eb20a80$a501280a@.phx.gbl...
> Dear
> I export the database table,SP,view,use..etc to script
> file. After i run the script to another server to rebuild
> the database. Only the table(index and constain) can't
> import to new database but i have choice the option(index
> and constain) when i export the database to script. What
> is ths problem?
> Many Thanks
> John

import data with different collation properties

Hi All,
I have to restore a database from a different collation name to my sql
server 2000 sp3.
This database has index, primary keys and so on.
After I restore the database if I try to do a relation I have an error.
Also if I try alter table with a new collation doesn't work because the
objects(index, ...)
How can I fix this? How can I import this database with my default
collation?
Tks
JohnnyYou can use COLLATE clause:
select 1
where
'Alejandro' collate SQL_Latin1_General_CP1_CS_AS = 'ALEJANDRO'
select 1
where
'Alejandro' collate SQL_Latin1_General_CP1_CI_AS = 'ALEJANDRO'
go
or you can dump the data into files, recreate your db with a new collation,
and load the data again (Uhhhh!!!).
AMB
"JFB" wrote:

> Hi All,
> I have to restore a database from a different collation name to my sql
> server 2000 sp3.
> This database has index, primary keys and so on.
> After I restore the database if I try to do a relation I have an error.
> Also if I try alter table with a new collation doesn't work because the
> objects(index, ...)
> How can I fix this? How can I import this database with my default
> collation?
> Tks
> Johnny
>
>|||Tks for you reply Alejandro,
uauuu.... It's not an easy way to change the db collation?
I tought this is an easy problem :)
JFB
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:1FF88CBD-9B30-45B1-A637-A1E7ED22D226@.microsoft.com...
> You can use COLLATE clause:
> select 1
> where
> 'Alejandro' collate SQL_Latin1_General_CP1_CS_AS = 'ALEJANDRO'
> select 1
> where
> 'Alejandro' collate SQL_Latin1_General_CP1_CI_AS = 'ALEJANDRO'
> go
> or you can dump the data into files, recreate your db with a new
> collation,
> and load the data again (Uhhhh!!!).
>
> AMB
>
> "JFB" wrote:
>

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.
Jason
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...
> 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...[vbcol=seagreen]
> 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
>
|||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?[vbcol=seagreen]
> 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
> any
>

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> ¦b¶l¥ó
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...
> > 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
> >
> >
>|||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> ¦b¶l¥ó
> 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...
> > > 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
> > >
> > >
> >
> >
>

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
>

import a large table

Hi,
I am importing a large table to a table. The table contains
27 millions rows with 1 or 2 index.
I used Enterprise Manager to do the table import. I see
the "status: 275" on the import screen after 27 millions
rows are inserted. The "status: 275" is on the screen
for 4 hours already. I used "simple" option for the
recovery.
Does import should take more than 10 hours for a 27
millons rows ?
Is there a way which I can use to make import faster,
e.g. command line import option ?
Thanks in advance.
MingTry using bcp to export the data to a file and import from
the file. Use the native format (/N).
Also set batch size.
Create the indexes after the import.
>--Original Message--
>Hi,
>I am importing a large table to a table. The table
contains
>27 millions rows with 1 or 2 index.
>I used Enterprise Manager to do the table import. I see
>the "status: 275" on the import screen after 27 millions
>rows are inserted. The "status: 275" is on the screen
>for 4 hours already. I used "simple" option for the
>recovery.
>Does import should take more than 10 hours for a 27
>millons rows ?
>Is there a way which I can use to make import faster,
>e.g. command line import option ?
>Thanks in advance.
>Ming
>.
>