Post reply

Impact of changing datatype

  • October 30, 2008 at 11:02 am

    #200852

    What wud be the impact of changing and INT to Varchar in production databases, what will be the best approach to do?

  • October 30, 2008 at 11:13 am

    #891998

    It would depend on how you are accessing the data in your production system.

    A front-end applicaiton that expects this value to be an int will fail if you change it to a varchar.

    If you have any procedures/views or functions that expect this value to be an int then they will also fail.

  • October 30, 2008 at 11:19 am

    #892002

    So 1st i need to find where that column is used in whole databases then change it every where.

    Is there any script which will find column and change datatype at one shot.

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

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