Adding Data to New Columns

reach4thelasersreach4thelasers Posts: 4
edited May 18, 2012 3:15AM in SQL Data Generator Previous Versions
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?
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • reach4thelasersreach4thelasers Posts: 4
    Well that's a serious limitation of your product. I'm going to have to look for another solution.
    · Share on Twitter
  • James BJames B Posts: 1,124 Silver 4
    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
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.