How to find the all table list in the order of reference

Question

How to find the all table list in the order of reference

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

binutb SSCommitted Points: 1741 More actions · Answer 1

Hi,

We are using Sync Frameworks for data replication.
In this method, required to specify tables which replicate to target database in a table creation sequential order.

that is the reason for table list in the creation sequential order.

Regards
Binu

Scott Coleman One Orange Chip Points: 27452 More actions · Answer 2

The only plausible interpretation of "table creation sequential order" to me is an order that puts referenced tables ahead of tables with foreign keys that reference them. Creation date is not involved in any way.

Now if the tool is going to blindly try to create tables (with their keys) in the order you specify, and some set of foreign keys create a circular reference, there is no correct answer. You may have to drop a foreign key or redesign the database to make it work.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Well, after many posts it looks like we are finally getting the information needed to better help. From the OP's latest post what is needed is to determine the order data will be replicated using Sync Framework. This really has nothing to do with the order in which the tables are created but the order that the data needs to be created in the target system(s) during replication.

A special note to the OP. You will get much better help if you provide ALL pertinent information up front instead of posting things in piece meal format.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 4

binutb - Friday, June 22, 2018 7:21 AM
Hi,
We are using Sync Frameworks for data replication.
In this method, required to specify tables which replicate to target database in a table creation sequential order.
that is the reason for table list in the creation sequential order.
Regards
Binu

If Sync Frameworks doesn't figure that out on it's own, I'd recommend looking into a different product.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

From what I have been finding I don't even know if Microsoft is actually supporting Sync Framework anymore.