September 9, 2022 at 9:02 am
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, with link would be helpfull.
yours sincerley
September 9, 2022 at 9:26 am
If these tables make the majority of data of that database, just restore the full database to a new database name and remove the ones you do not want to transfer.
You can also script out table definitions ( table/indexes/defaults/FK/..) optional including the data and run that at the target database.
Keep in mind, powershell dbatools module has nice functions to help you out. ( Copy-DbaDbTableData )
# copy table including data
Copy-DbaDbTableData -SqlInstance Yourceinstancename -Database 'yourcedb' -Table 'yourtable' -Destination TargetInstanceName -DestinationDatabase TargetDb -AutoCreateTable
( you may need to check if it also copied all indexes and DRI information )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution π
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 9, 2022 at 9:40 am
thanks , Has SSDT got any transfer feature?
September 9, 2022 at 9:53 am
I don't use SSDT, but you can check it all at " Compare and Synchronize Data in One or More Tables with Data in a Reference Database "
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution π
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply