Solved

Syncronize two MS SQL Server 2005 with SSIS

Posted on 2009-07-14
5
225 Views
Last Modified: 2012-05-07
Hello,

is it possible to synchronize two MS SQL Servers 2005 with SSIS
do you know a tutorial.
German would be fine.

best regards
0
Comment
Question by:Rockfabrik
  • 2
5 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 167 total points
ID: 24847306
Yes this would be possible but would be more more work than some of the usual built in features.
Have you considered log shipping or replication?

What type of sync is required? real time or end of day?
You could restore your other DB using a backup taken at the end of the day from the main DB
0
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 333 total points
ID: 24847495
>>is it possible to synchronize two MS SQL Servers 2005 with SSIS<<

Is there any specific reason to go for SSIS only?

personally I would prefer log shipping, mirroring or replication.
0
 

Author Comment

by:Rockfabrik
ID: 24847828
Hello,

there are different Databases with different designs. I want to catch some data from some tables of one an put it into the other.
Is it possible to call this from ASP.NET C# Code Behind?

best regards
0
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 333 total points
ID: 24847835
well in that case you should go for SSIS rather than C#.  have a look at small tutorial.

http://www.accelebrate.com/sql_training/ssis_tutorial.htm
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now