topic Re: COPY Databse objects (pk, fk, roles, indexes, ...) in Talend Studio

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

Anonymous — Wed, 26 Sep 2018 14:34:09 GMT

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

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

fdenis — Thu, 27 Sep 2018 08:59:23 GMT

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

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

Anonymous — Fri, 28 Sep 2018 08:40:28 GMT

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

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

fdenis — Fri, 28 Sep 2018 08:58:04 GMT

You can also use backup restor.

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

fdenis — Mon, 01 Oct 2018 08:57:08 GMT

did you success on your task?

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

Anonymous — Mon, 01 Oct 2018 10:28:57 GMT

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

Thank's fot asking !

should i close the topic ?

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

fdenis — Mon, 01 Oct 2018 10:34:38 GMT

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