Trying to select View for synchronizing data

Ne, 10/03/2010 - 20:59 — Anonym

I can add Table but not View for source in synchronizing data. Why?

English

Ne, 10/03/2010 - 23:14 — Anonym

You can add view as source,

You can add view as source, if you add target table using "Add table" and than change synchronization source to view.

I will consider to add more commands to make it clear... In case of problems, please let me know

odpovědět

Po, 10/04/2010 - 22:25 — Anonym

I run datadmin. Then Tools ->

I run datadmin. Then Tools -> Synchronize Data, then select the source and destination and then only Add Tables!!!

The problem is that I have no tables to add at all, only views.

So you need to add "Add Views" and not only "Add Tables".

The DB that I connect (MS SQL 2005) it's not mine so I can not add a Table and then change it to View.

Can you make that addition?

btw, when I click on the "Synchronize Structure" I get "... you need higher edition, ... Professional tools" what's that? How can I have Synchrozine Data without Structure? Is that Logical?

odpovědět

Po, 10/04/2010 - 23:02 — admin

"Add tables" means tables from target database - it is not possible to set view as target (in most cases it doesn't have sense, only when view is updatable, but this is quite rare and problematic case...). You can than select source view.

But you are right, now it is not very clear, I will add button Add Views or make other improvements to better usage...

Synchronize data assumes that structure is prepared (you can setup data synchronization between different structures - eg. when source data are in views and target data are synchronized into tables, it is independend on structure synchronization). If you need both features (data and structure synchronization), you can install both licenses - Professional and Data Synchronization (also trials for both licenses are available).

odpovědět

Út, 10/05/2010 - 09:59 — Anonym

1. The source is MSSQL 2005

1. The source is MSSQL 2005 VIEWS and the target is MySQL TABLES. Do I need to create the structure first or is the structure of the VIEWS be identical by default in the target MySQL TABLES?

2. I do NOT have created any TABLES in MySQL yet. Do I need to create them myself or the data-sync will create them the first time the sync will take place? I don't want different structures as source and destination. The VIEWS will be exactly the same in the destination but just in TABLES instead of VIEWS.

3. When I select the SOURCE and DESTINATION I don't see anything in the table below as you have in you picture above ie. Source: "dbo.Customers and suppliers by City" and target "dbo.Categories". Why is that?

odpovědět

Út, 10/05/2010 - 22:27 — admin

Thank you for clarifying 1.,

Thank you for clarifying

1., 2.
Data synchronization does only data operations, structure must be allready prepared. So you should create tables in target database before you setup data synchronization.

Now it is neccessary to create target tables manually, I will add option Generate SQL/CREATE AS TABLE into View context menu (which will generate CREATE TABLE SQL command, created table with the same structure as query), which will with help this task in some future version

3.
In source dropdown-list you should see list of views (if source is set to View), in target dropdown-list list of tables of target database. So if target database is empty (without any structure), you will see nothing