COPY Databse objects (pk, fk, roles, indexes, ...)

[Anonymous]

Hello everybody,

i'm new on Talend open studio, i used to be on MS SSIS and i would like to know if there is a Talnd component to copy some SQL Server a source database objects like role, pk, fk, indexes, ... to another SQL Server destination database

On SSIS there is "Transfer SQL Server Objects Task Editor" and i can choose which object i can transfert (pk, role, indexe, schema and data)

i did not find on internet

Thank you all

best regrds

[fdenis]

there is no copyObject on talend.
because the structure of each db source and db destination are not the same. Think mssql to MongoDB!
you can do it by yourself using system table as source.
calling administration function on destination.
Good luck

[Anonymous]

Thank you for this reply. 

OK i understand.

In my case i have the same structure for source and destination mssql db.

The problem is i have too many and i would like to set indexes, pk, schemas and roles from source to destination db.
I think that i will drop and recreate tables with "generate script wizard" (with indexes and pk) and copy data with a sql query insert into select *

Thank you fdenis

[fdenis]

You can also use backup restor.

[fdenis]

did you success on your task?

[Anonymous]

Hello Yes i did it with SQL queries now i wait for QA users (tests)

Thank's fot asking !

should i close the topic ?

[fdenis]

ok, so, can you tag as Solved?
see you next time.