Red Gate forums :: View topic - Refreshing of Constraints
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Refreshing of Constraints

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
acheton



Joined: 13 Sep 2011
Posts: 1

PostPosted: Tue Sep 13, 2011 12:30 pm    Post subject: Refreshing of Constraints Reply with quote

Hi all,

I am a new users trialling SQL Generator, I have come across an issue which I cannot find my way around. I have a new Project created which imports some data into a database. SQL Generator seems to honor all of the constraints when generating the schema for the first time. However when I add a new constraint to a column in the database and refresh the Schema or close and reopen the Project the new constraint is not honored with the test data. I have tried all sorts of things but nothing I do seems to make it update the test data based on the new constraint - thsu when I rerun the generation it fails.

Any suggestions or advice?

thanks,


Ach
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed Sep 14, 2011 3:11 pm    Post subject: Reply with quote

Thanks for your query regarding SQL Data Generator.

Usually, refreshing the schema should get it up-to-date with the server, although depending on what generators you used on the fields in question, you may need to go and alter some settings there.
Does the problem still occur if you just start a *new* project with the updated schema rather than re-opening the old one? If not, then it sounds like something is stored in the project that doesn't get updated.

If you could send over a simple reproduction to support@red-gate.com, quoting F0052169 in the subject line then we can investigate in more detail and log a bug if necessary.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group