| Author |
Message |
reach4thelasers
Joined: 08 May 2012
Posts: 3
|
 Posted: Tue May 15, 2012 10:42 am Post subject: Adding Data to New Columns |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Wed May 16, 2012 5:12 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
reach4thelasers
Joined: 08 May 2012
Posts: 3
|
| Posted: Thu May 17, 2012 10:15 am Post subject: |
|
|
| Well that's a serious limitation of your product. I'm going to have to look for another solution. |
|
| Back to top |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 842
Location: My desk.
|
| Posted: Fri May 18, 2012 8:15 am Post subject: |
|
|
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 |
|
|
|
|
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
