precautions for conversion

Hi,
I am in the process of converting all char and varchar
colums to nchar /nvarchar ...I am done with all the
scripts required for conversion..Can someone help me in
precautions to be taken care while doing this upgrade
like data file size , log file size etc......
SridharIf you are changing the column datatypes on a big table, make sure you have
enough space on the log drive, to allow the log to grow.
If you have any constraints (like defaults, indexes, primary and foreign
keys etc.) defined on the columns being altered, make cure you remove those
before the alter and readd them later.
if the tables are related using multiple foreign keys, then you'll have to
drop the constraints in the right order and readd them in the right order as
well.
Make sure you test your scripts in your test environment.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:dcf301c43bf0$dc370680$a401280a@.phx.gbl...
Hi,
I am in the process of converting all char and varchar
colums to nchar /nvarchar ...I am done with all the
scripts required for conversion..Can someone help me in
precautions to be taken care while doing this upgrade
like data file size , log file size etc......
Sridhar|||Thanks..I have taken care of the dropping
constraints ,indexes and adding them in ordered way in my
script...i am worried about the log and data file size
growth...
>--Original Message--
>If you are changing the column datatypes on a big table,
make sure you have
>enough space on the log drive, to allow the log to grow.
>If you have any constraints (like defaults, indexes,
primary and foreign
>keys etc.) defined on the columns being altered, make
cure you remove those
>before the alter and readd them later.
>if the tables are related using multiple foreign keys,
then you'll have to
>drop the constraints in the right order and readd them in
the right order as
>well.
>Make sure you test your scripts in your test environment.
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:dcf301c43bf0$dc370680$a401280a@.phx.gbl...
>Hi,
>I am in the process of converting all char and varchar
>colums to nchar /nvarchar ...I am done with all the
>scripts required for conversion..Can someone help me in
>precautions to be taken care while doing this upgrade
>like data file size , log file size etc......
>
>Sridhar
>
>.
>