What are the challenges you face when working across database platforms? Take the survey
Options

SQL Generator and Schema Changes

JohnMJohnM Posts: 6
I created my database schema in SQL Server 2008. I then opened SQL Generator (v.1.2) which recognized my new schema. I later modified the data type of a column through SQL Server Management Studio; but I cannot get this change to be reflected in SQL Generator. Please advise.
-John

Comments

  • Options
    I take it that you've tried refreshing the schema, after opening your project? This should go and 'grab' the latest version of your schema including the recent changes. Just click the 'Refresh Schema' button next to the 'Save Project' button.

    If you've already tried this without success could you give me a little more information? i.e. what was the data type of the column changed from and to?
  • Options
    The Refresh Schema was tried; but ultimately the issues wasn't with SQL Generator... it was just user error.

    Thank you!
    -John
Sign In or Register to comment.