March 4, 2008 at 12:25 pm
I have a list of tables which I would love to copy among databases. How I first check the existence of them and then copy after. Like
I have table123 to be copied from databaseAAA to databaseBBB. Any ideas !?
March 4, 2008 at 12:47 pm
you can use DTS for this.
from EM in the table pane rightclick and select import/export data....
You can save the package and schedule it if needed.
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
March 4, 2008 at 12:50 pm
Thank you for the quick response. If I would like to put them in a SP, would it be possible ??? This request is just part of the SP.
March 5, 2008 at 3:08 am
actually your full sp might be replaced by one dts package.
If you don't need things to be synchronized online-realtime, switch to DTS !
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
March 5, 2008 at 8:06 am
You may use IMPORT/EXPORT data. It is faster to setup.
March 5, 2008 at 9:35 am
Thank you guys for the suggestion and advice. I receive this project to develop a SP instead of using the DTS or Import/Export. Another reason copying parameters come from users like company name, table name are controlled by input of user.... That is why I need to capture those request through SP and run. Any new ideas !?
March 6, 2008 at 6:30 am
Yes, and the result is for the Management group to make decision. Thanks.
March 6, 2008 at 7:27 am
I would not prefer using linked tables for this, but it can be used.
Is this copy realy needed online-realtime ?
Prefer the assynchrone way !
e.g.
use a sqlagent job to refresh the data on a regular basis, ...
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 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply