SQL Generator and Schema Changes

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

SQL Generator and Schema Changes

Postby JohnM » Thu Sep 11, 2008 1:55 am

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
JohnM
 
Posts: 4
Joined: Tue Sep 09, 2008 3:03 am

Postby Ben Pinchen » Mon Sep 15, 2008 3:03 pm

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?
Ben Pinchen
 
Posts: 157
Joined: Thu Dec 28, 2006 1:21 pm
Location: Red Gate

Reply

Postby JohnM » Tue Sep 16, 2008 2:33 am

The Refresh Schema was tried; but ultimately the issues wasn't with SQL Generator... it was just user error.

Thank you!
-John
JohnM
 
Posts: 4
Joined: Tue Sep 09, 2008 3:03 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests