How to Convert 1C:Enterprise AccountingSuite database to some other database

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Dec 3, 2013
Company: Claritus Consulting

Hi

Can we convert database(integrated) to some other database preferably to SQL Server database.
What i have come to know that 1C stores the data in .1CD file format.
I am looking for a way to extract all the tables from there.

Thanks
Prashant Arora

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

Hi,

If I've understood correctly, you need to migrate the data from one InfoBase (currently working in file mode) to another (SQL Server-Based). You can do this using Designer by dumping the current InfoBase (Administration - Dump InfoBase) and restore it (Administration - Restore InfoBase) in the new InfoBase created on 1C:Enterprise server.

 
#3
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Dec 3, 2013
Company: Claritus Consulting

Hey Daniel

I'm new to 1C:Enterprise, so i'm using training version for now.
Actually I need to use the database being used in 1C:AccountingSuite in SQL Server
In training version there is no option available to migrate it to sql server.

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

But do you have a full version of 1C:Enterprise available? Because Client/server mode (SQL server architecture) is not supported on the training version.

 
#5
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Dec 3, 2013
Company: Claritus Consulting

No Daniel, currently i have only training mode available. Before getting the full version I'd like to know how can we do migration of database used in 1C platform to SQl Server. Is there any demo available to my need?

And what I exactly need to purchase, 1C concurrent user license or 1C Server license or both?

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

Joined:
Company:

Hello, Prashant Arora.
Unfortunately there is no demo that works in client/server mode without license. To use client/server mode you need both licenses for server and for clients.
The procedure of migration from file mode to client/server mode is easy as 2 clicks: you export entire infobase as .dt file in file mode infobase and import it in client/server mode infobase.

 
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.