Forum

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

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.

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.

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.

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?

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.