locked
Can i make changes to .aspx files ? RRS feed

  • Question

  • when we need to add or edit a member on a entity, for columns with foreign key, we get a search box to look up the value. Here the default search is based on name. We want the code to be the default search column. I see that when i changed in the backend .aspx file and restarted IIS, the change happened and now the default search is code. I just want to know if there will be any impacts going forward ? may be during upgrades or migrations ?

    Thanks in advance !

    Monday, August 31, 2015 1:39 PM

Answers

  • You can go so far as to delete and re-create the web site whenever you want.  But, again, making changes to the MDS web site is not supported, so you're on your own.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Proposed as answer by Charlie Liao Monday, September 7, 2015 2:41 AM
    • Marked as answer by Charlie Liao Wednesday, September 9, 2015 3:37 AM
    Monday, August 31, 2015 6:14 PM

All replies

  • > I just want to know if there will be any impacts going forward ?

    Any changes would be unsupported, may revert on an upgrade or may simply break after an upgrade.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Monday, August 31, 2015 3:10 PM
  • davidbaxterbrowne

    Thanks David. If i revert my changes before going for an upgrade, do you think, that will avoid issues during upgrades ?

    Monday, August 31, 2015 6:12 PM
  • You can go so far as to delete and re-create the web site whenever you want.  But, again, making changes to the MDS web site is not supported, so you're on your own.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Proposed as answer by Charlie Liao Monday, September 7, 2015 2:41 AM
    • Marked as answer by Charlie Liao Wednesday, September 9, 2015 3:37 AM
    Monday, August 31, 2015 6:14 PM
  • which SQL Server version are you using?

    Are you using SQL Serve 2008? From SQL Server 2012, the DBA/Foreign key picker is hosted in sliverlight, which you can specify more complicated query on name/code and other attributes.

    Monday, August 31, 2015 6:25 PM
  • I am using SQL Server 2008 R2
    Monday, August 31, 2015 6:43 PM
  • >I am using SQL Server 2008 R2

    Please consider upgrading to 2012 or 2014.  MDS in SQL 2012+ has a lot of improved functionality, and quite a few bug fixes were never back-ported to 2008 R2.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Monday, August 31, 2015 9:49 PM
  • Hi Swapna,

    In your scenario, in order to make the code to be the default search column, you changed in the backend .aspx file and restarted IIS which works fine. Now you need to know if there will be any impacts during upgrades or migrations, right?

    As David said, any changes would be unsupported. And it would lead some unpredictable issue. So it is not recommended to change the .aspx file. If you have any concern about this behavior, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

    Thank you for your understanding.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, September 7, 2015 2:40 AM