Data exchange - Creation of initial image for distributed infobase subordinate node

1C:Enterprise platform integration capabilities and techniques

#1
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Mar 8, 2012
Company: Smart ID

Hello,
Is there a faster way of creating the original image of an infobase other than using the standard mechanism (managed form)? I've made some tests and the standard mechanism can take some time for large databases.

I intend to create an initial image for an infobase containing tens of gigabytes of data, so I need to accomplish this in the most optimal way possible. The infobase works in server mode - MS SQL Server architecture.
I was thinking maybe to simply backup the corresponding database from SQL Server Management and restore it in a new database. But in the end I will have a problem with 1C:Enterprise seeing this new database as a distributed infobase subordinate node.

 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Daniel, the initial image is created with processing of data in infobase as only data belonging to a specific node will be exported. In your case it should contain entire the data but in other cases it is not.

Maybe you could limit data for your node as in case of problems when you will need to restore the distributed infobase, this will take a long time.

 
#3
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Mar 8, 2012
Company: Smart ID

So the standard mechanism would be the only way of creating the initial image of a specific node.

When you talk about limiting the data for the node you refer at filtering the data which is sent fr om master to slave node?

In my case, the data will need to be send just in one direction, from main to backup infobase. At first, I will need to create the initial image for backup node, after which the new/changed data from main infobase will be send to backup infobase periodically. But almost all of the metadata objects from the configuration must be part of the exchange plan (AutoRecord enabled), so I don't think I will can lim it the data to be sent.

 
#4
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jan 23, 2013
Company: OTTO

Quote
In my case, the data will need to be send just in one direction
I think MS SQL, Asynchronous Database Mirroring (High-Performance Mode) is the best variant.

 
#5
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Mar 8, 2012
Company: Smart ID

Alexey, after creating the initial image of the main infobase, data older than a certain date will be deleted from the main infobase in order to work only with recent data (for better performance). But this deletions will not be recorded for backup node, so that the old data could be found at any time in the backup infobase. I don't know if the database mirroring mechanism can allow me to implement such scheme, haven't used it before.

 
#6
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

It will be more useful to create new infobases yearly, for example and keep there opening balances and catalog items only. In that case you will have as backups fully functional infobases with data by years.
If you would sign a partnership with 1C Company, you could have an Extended TechSupport option and our specialist could assist you with performance issues of your infobase.

 
#7
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Mar 8, 2012
Company: Smart ID

Thanks for all the suggestions.

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.