Red Gate forums :: View topic - WHERE Clause
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

WHERE Clause

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JVM65



Joined: 20 Apr 2012
Posts: 2
Location: Stockholm, Sweden

PostPosted: Fri Apr 20, 2012 11:32 am    Post subject: WHERE Clause Reply with quote

I'm using SQL Data Compare to populate my test environment with some data from the production environment.

This can be done with a WHERE Cluase for each table that want to filter, like

ID IN
(SELECT ID FROM TestDB1.[dbo].TestTable_ID)

Is this the best way to do it when you just need a small selection of data for test?

My database consists of more than 100 table and I don't want to edit a WHERE Clause on every table.

/Janne
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Fri Apr 20, 2012 4:25 pm    Post subject: Reply with quote

Unfortunately, this is the only way to do what you want to do in SQL Data Compare.

However, we have an alternative tool called SQL Data Generator which is specifically designed to aid with the insertion of test data into development databases. Using this tool you can specify your test database in the project and specify the number of rows to generate (in Tools > Application Options > Generation tab and Specify number of rows).

At this point you will need to make a decision. Either generate 'random' nonsense data into the tables, or specify your source tables (containing the data). Unfortunately, the latter will need to be done for each table individually . But the former, will be much quicker to set up (as it uses 'random' data generators as standard).

http://www.red-gate.com/supportcenter/content/SQL_Data_Generator/help/2.0/SDG_Mapping_SQL_tables_or_views

But if you have any questions then please let me know.
_________________
Chris Kelly
Technical Support Engineer


Last edited by chriskelly on Mon Apr 23, 2012 11:51 am; edited 1 time in total
Back to top
View user's profile Send private message
JVM65



Joined: 20 Apr 2012
Posts: 2
Location: Stockholm, Sweden

PostPosted: Fri Apr 20, 2012 5:32 pm    Post subject: Reply with quote

OK

Thank you for quick respons.


/Janne
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