Wayne;

Good advice. May I add two?
Understand Triggers.
Understand SQL Server Data Types.

Tom


>Get 2-3 SQL Server books - read them from cover to cover. Get both SQL Admin and Development type of books.
>Understand how to administer the database and server
>Understand the users and roles and how you want to incorporate them in your app.
>Understand how to search for problems in the server - sql profiler, management/activity, etc.
>Understand how to backup - restore.
>Determine how you will run a testing and production db - how will you connect?
>Learn about maintenance on the db?
>What about a report database (warehouse)?
>Understand views, stored procedures, user defined functions.
>Understand indexing on the tables - clustered/non-clustered - benefits (why you would use each)
>Design your database
>Create your database
>Use names for objects in the database that make it easy to visually administer - tblap... (Accounts Payable tables), tblpo... (Purchase Order table)
>
>After you've got all this - then start designing your app.
>
>-w-
>
>
>>Hi Bernard,
>>
>>I look forwards to the opportunity to exchange ideas of migrating DB to SQLServer. I think I will start a new thread here.
>>
>>As you can see, I am at the very early stage of the conversion. So any experiences/suggestions will be greatly appreciated.
>>
>>Thanks