Red Gate forums :: View topic - Adding Data to New Columns
Return to www.red-gate.com RSS Feed Available

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

Adding Data to New Columns

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
reach4thelasers



Joined: 08 May 2012
Posts: 3

PostPosted: Tue May 15, 2012 10:42 am    Post subject: Adding Data to New Columns Reply with quote

I've got a very complex database with a mixture of SQL Generated Data and manually entered/real data. I've added a couple of columns to one of the tables - just Firstname Lastname and I want to use SQL Data Generator to populate only these two columns.

How do I do this?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Wed May 16, 2012 5:12 pm    Post subject: Reply with quote

Hi,

Unfortunately, SQL Data Generator, due to its' design, can only blast data into a whole table. You cannot select or deselect individual columns to populate.
Back to top
View user's profile Send private message
reach4thelasers



Joined: 08 May 2012
Posts: 3

PostPosted: Thu May 17, 2012 10:15 am    Post subject: Reply with quote

Well that's a serious limitation of your product. I'm going to have to look for another solution.
Back to top
View user's profile Send private message
james.billings



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

PostPosted: Fri May 18, 2012 8:15 am    Post subject: Reply with quote

The workaround to this kind of problem is to restore a temporary copy of your database and use this as the source data for all the columns you want to keep the current data in. You can then use the generators on the remaining new columns. It's obviously not an ideal solution but the end result is the same.
There's an article that covers these ideas here
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