1. Charles Fahey
  2. Valentina Studio
  3. Четверг, Июль 06 2023, 07:50 PM
  4.  Подписаться через email
Hi All,

I'm hoping someone can give me some insight into Data Transfer and Diffs.

I'm considering buying the Pro version of Valentina Studio, but the demo hampers the functionality, and the documentation isn't super clear.

Two areas of concern:

1) When performing a data transfer between two servers, are schemas copied as well the data? What about indexes, foreign keys, etc.? Will it perform an identity insert as needed?

2) When performing a diff, does it only diff the schema, or does it diff the data? Is it possible to use this feature to perform final syncs of only diffed data? And if so will it support identity inserts?

Very excited by this product. Thanks all for your help!

- Charles
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Charles,

Is it for SQL Server or PostgreSQL?
Support identity inserts - inserting existing values to identity fields, right?

1) Data Transfer is only for data.
For SQL Server, SET IDENTIFY_INSERT [table_name] ON/OFF is executed.
For PostgreSQL, it is necessary to change Generated Always property value to OFF to allow insertion.

If the value for a field is generated with NEXT VALUE FOR/nextval the sequence is updated automatically.

2) SQL Diff is for schema
Комментарий
There are no comments made yet.
Charles Fahey Ответ принят
Thanks Sergey!

Sorry about that - I should have specified it is for (MS) SQL Server.

And thank you - this info is very helpful.

Have a great day!
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories