Hello

Project need to copy data "transfer oneway" from sybase database to different Database. But I guess use LLBLGen for this task is the best idea and I like to ask if somebody has a short idea how to do this best way?

Thanks

Roman

Do they have the same structure? I mean the same Tables and fields?

Hello

Yes the same structure may additional fields but is not important for the import.

Here are some steps I think would be useful in your case:

1. Create one LLBLGen project per DB.

2. Before generate code for every project, change the _ConnectionStringKeyName _property on the Project properties at LLBLGenPro Designer. For example: PrimaryDB.ConnectionString SecondDB.ConnectionString ...

3. Before generate code for every project, be sure that the root namespaces are different between projects.

4. Create a VSNet DataTransfer project and reference all your DB generated code projects (two if you are using Adapter templateSet and one if you are using SelfServicing).

5. Setup the config file of your transfer application so all your connection strings are provided (see point 2).

6. At import/using section of your code files, write the namespaces in the way that wouldn't exist ambiguities.

7. Write your data transfer code and good luck