i want to transfer tables with indexs and tringgers from one database to other

Question

hi,

I have some tables with indexes fks , triggers which I want to transfer with data to other an other database,

pls tell me if any good tool is there, i tried to take out script with data but it does not transer image column and  i have image columns also , then i tried export feature it transfered image col also but it did not transfered indexs and triggers etc.

so kindly tel me if any new feature is there,
somebody said SSDT has , i am new to ssdt so pls send me specific link or min steps.

yours sincerley

Answer 1

i tried to take out script

How/With which tool?

tried export feature it transfered image col also but it did not transfered indexs and triggers etc.

The Export/Import wizard creates only the plain table without anything else, even not the primary key.

You can use the Script Generating Wizard of SSMS:
https://learn.microsoft.com/en-us/sql/ssms/scripting/generate-scripts-sql-server-management-studio?view=sql-server-ver16

Answer 2

Hi @rajesh yadav ,
Maybe you can import your database in the form of .CSV , and then you can try other ways to keep the image cols data indexes and triggers. (maybe the pandas I/O, I won't recommend or suggest, I just hope can give some inspirtaion, and you can research on your own)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 3

Hi @rajesh yadav
How about the problem? :)