# Check if the record already exist

**URL:** <https://forum.cloverdx.com/t/check-if-the-record-already-exist/137>\
**Category:** CloverDX Platform\
**Created:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/check-if-the-record-already-exist/137 "2007-07-16T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/check-if-the-record-already-exist/137/1 "2007-07-16T00:00:00Z")

</div>

Hello, i’m new in cloverETL, i would like to ask if is’t possible to check if the record is already exist in the database? thnx…

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/check-if-the-record-already-exist/137/2 "2007-07-16T08:23:44Z")

</div>

Yes, it is possible. Consider using some of join components. What do you exactly want to do?

OtaSanek

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/check-if-the-record-already-exist/137/3 "2007-07-16T08:23:45Z")

</div>

Hi, here is the scenario. I have a database(db1) which will bhe migrated to a New Database(db2)… these databases have different structures… For now, i can migrate data from db1 to db2 but some of the tables in db2 contains records already. when i try to migrate data from the table which has records, an error occurs(Unique constraint). thats why i want to check first if the record that will be migrated to db2 is already exist… is it possible??? thnx…