Very Computer

I have a database with dictionary case insensitive sort order in SQL server
7.0.

Now i need to convert that database into SQL Server 2000 with binary sort
order.

Can you please give me a best method of doing this.

FYI

I used DTS no use

I used copy database but no use

The database has 4000 tables.

Raju

You don't say what about DTS was no use, so a little more detail might help
someone here.  I would expect DTS to be just fine.

However, here is a relatively straightforward way if we assume that the data
itself does not need to be converted.

BCP from SQL Server 7.0 all tables out to files on the OS file system.

BCP all those files into tables on the new SQL Server 2000 database.

Now, should your data need to be converted due to collation changes it is a
little more complex.  You could research 'collation' in the BOL.

Russell Fields

Quote:

> I have a database with dictionary case insensitive sort order in SQL
server
> 7.0.

> Now i need to convert that database into SQL Server 2000 with binary sort
> order.

> Can you please give me a best method of doing this.

> FYI

> I used DTS no use

> I used copy database but no use

> The database has 4000 tables.

> Raju

Can you not restore the 7 database to 2000.  2000 has the ability to
have a different setting in each database.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE, MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community for SQL Server
professionals - http://www.sqlpass.org