We need to update our start up .sql files to use nvarchar and ntexts to store text fields We need to create a way that we can convert existing MSSQL implementations to nvarchar and ntext mideas ...

Is NVARCHAR in SQL Server the same or similar to VARCHAR2 in Oracle? I might be wrong but doesn't SQL Server also support VARCHAR2? If so, what benefits (or problems) come from using NVARCHAR?