User profile for pk_davidson

Well, here I am on version 3.7.0.2 and this is still happening to me. It is now only occurring on my test server and fortunately not on production but still it's so very annoying. What's even more annoying, I deleted the triggers from the database completely. I suspect (HOPE) this is an error from an old issue that was never cleaned up? I'm hoping one more dive into workingbases and I never see this again? / comments

Well, here I am on version 3.7.0.2 and this is still happening to me. It is now only occurring on my test server and fortunately not on production but still it's so very annoying. What's even more ...

0 votes

Good question... I assume you mean roll back your redgate install ? You can get old versions at: http://www.red-gate.com/supportcenter/G ... d_versions But I'd suggest you contact support. They may not be aware of this problem, since no one has chimed in on this thread... And your products are tied together and then there's the question of what about having committed with the newer version ? Can you simply go back ? / comments

Good question... I assume you mean roll back your redgate install ? You can get old versions at:http://www.red-gate.com/supportcenter/G ... d_versions But I'd suggest you contact support. They may ...

0 votes

Just for clarity sakes: I modified only my schema, only in one table. I did not touch the trigger files but the table does have two trigger files associated with it. After cleaning up the first problem with the modified table (the code in the base had put in the two trigger creations twice), I then had to clean up another table which also had one trigger file that was in the base code twice. Also, I didn't use a migration script, I was just committing changes directly from SSMS via SQL Source Control: Commit Changes tab. / comments

Just for clarity sakes: I modified only my schema, only in one table. I did not touch the trigger files but the table does have two trigger files associated with it. After cleaning up the first pr...

0 votes

I am just now having this same problem pop up. I'm trying the suggestions here but have no idea what I did that caused this to start happening. I had modified the schema to add (5) new vchar fields and then committed the changes. I had recently added SQL 2008 R2 to my dev machine and this was the first time I worked in SSMS since then. I was working in SSMS 2005 not the latest installed 2008. I have the 2008 engines all set to start manually only so they won't take up memory. we are still using 2005 but I needed 2008 R2 to look at some other servers in the organization. Scary that it looks like there have been no RedGate responses to this yet and it's been posted for almost a month now. EDIT- so I followed J.'s suggestions and was able to eventually clean up my source control version. It was a cascading problem. I would clean up one table definition then committ the changes from the working base (thank you THANK YOU for the right click trick, I would have been clueless without it). Then another audit trigger would should up with a duplicate definition in it in another table ! What was also very strange and very concerning was that for my table with the original problem, the apparent committ that hosed everything also dropped all of my Foreign Key relationships that pointed to the primary key in that table ! Fortunately, my local copy still had these so I just had to continually committ those changes back to the source control until it "stuck" and no more duplicate triggers showed up. I too would sure like to know how to report this as a bug to redgate because it seems to be something fairly new and has happened to a handful of people now. What say you redgate sysops ? Any ideas as to what's causing this ? mucking around in the working base leaves me feeling a bit uncomfortable. / comments

I am just now having this same problem pop up. I'm trying the suggestions here but have no idea what I did that caused this to start happening. I had modified the schema to add (5) new vchar fields...

0 votes

Brian: I see no where to select columns. I went through the Use existing data source, browsed to the CSV file, made sure the columns were mapped correctly to the appropriate data types. I can see the data read correctly in the CSV File Data Import Settings dialog box. But when I click Finish, the preview of data is still showing random data and if I click Generate Data, it will import the random data, not the csv data. I've read through help, searched this forum and nothing seems to work. I click on a column in Tables to Populate and look at the Column generation settings and the only option I have for the two foreign key fiels is Foreign Key generator. I want to read those from a CSV file! I can set a string and date field by click on the columns and going through the entire browse and map again but this begs the question, why did I did it in the first place for the table in the first place ? It appears that the populate from csv will not populate FK fields ? / comments

Brian: I see no where to select columns. I went through the Use existing data source, browsed to the CSV file, made sure the columns were mapped correctly to the appropriate data types. I can see ...

0 votes

I'll look at it again Brian. But sure thought I had everything selected correctly... / comments

I'll look at it again Brian. But sure thought I had everything selected correctly...

0 votes

CSV import not working

I have a very simple table (many to many) that I am trying to populate from a csv file. There are only 5 columns. Primary Key, Foreign Key 1, Foreign Key 2, LastUpdateBy, LastUpdate I run the SQL ...

3 followers 5 comments 0 votes

Sounds good... But it requires having SQL Compare :? While that's in the pipeline, in the meantime, I just have to remember to unlink before a restore then relink... / comments

Sounds good... But it requires having SQL Compare :? While that's in the pipeline, in the meantime, I just have to remember to unlink before a restore then relink...

0 votes

We have the same issue as described in this thread. Obviously, if we had some of the other red gate tools, it wouldn't be as much of an issue with keeping data synched up. So I was pleasantly surprised to be able to find this thread as I wasn't even sure how to craft a query... I am curious, does the cleaner utlity also apply to subversion or other SCCS ? It would be nice if there were some way to deal with this situation without having to unlink and relink... I guess SQL Data Compare is that answer. / comments

We have the same issue as described in this thread. Obviously, if we had some of the other red gate tools, it wouldn't be as much of an issue with keeping data synched up. So I was pleasantly surpr...

0 votes

How can we help you today?

pk_davidson

Activity overview