June 2, 2014 at 2:36 am
We have to move data from one domain to another, and we have to be sure, that the data has arrived. The easy way would be an SSIS package using transaction, but it is not possible/allowed to open the necessaries ports for DTC in the firewall.
What is the alternatives? Copying files (xls,xml,csv) between source and destination server with some kind of a stamp, and then load data to database, use FTP to move files between source and destination, or use staging tables. Other ideas?
June 2, 2014 at 4:55 am
Is this just a straight load? Are the destination tables empty or is there already some data present?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 2, 2014 at 4:57 am
You can have trusted domain. If not possible you can BCP/SSIS to CSV file, transfer file to destination location and do BCP/SSIS in.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 2, 2014 at 2:45 pm
Diske (6/2/2014)
We have to move data from one domain to another
First, it is not completely clear what you mean "move data".
Is it one-time move of entire database(s) from one place to another, and all applications will be re-connected to the "new" domain? If this is exactly what the case, the best option would be backup/restore.
If you need to constantly reproduce the data on another domain/server while it is being changed on the source, try replication.
June 2, 2014 at 3:27 pm
I have to agree with SQL Guy 1 above.
Define "Move Data". One shot vs. continous vs. scheduled. Mirror/snapshots, Transactional Replication, Backup/restore, Log Shipping, Bulk Data Files, and scripting are all on the table still. Which one is best depends on other circumstances, one of the primary of which is how often is this occuring and for what intent?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply