Post reply

Database Migration

  • September 10, 2008 at 8:55 am

    #131184

    Hi Guys,

    I want to migrate the data from a Non-Unicode Database to a Unicode database.

    Problem:I already have a database with more that 100 tables and each of these tables has a columns with datatype varchar.I want to chage all of these to use Nvarchar(Same with text Ntext).

    This requirement is for the Turkey as they have a Unicodec dependent database.

    Please advice or help how to acheive this?

    This ia a Little urget please help me out as soon as possible.

    Share some dynamic sqls if you have which can solve this issue.

    Thanks

  • September 10, 2008 at 9:44 am

    #869769

    Rather than changing every field, you may want to figure out which fields actually need to be unicode and only change them. Depending on what applications connect and how other programming has been done, doubling the size of every character field may be a real big problem.

  • September 10, 2008 at 9:59 am

    #869782

    Thanks for the reply.

    Its a web based application that accesses this database.

    So we have to change all the feilds which are varchar to nvarchar.

    We are doing all these as we missed to Select Unicode option while creating the database.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply