Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asritha
Starting Member
4 Posts |
 Posted - 2011-06-10 : 13:25:51
|
| I have a criteria to do replication on Sql Server 2008 R2.Below are the points to be considered while doing Replication.Can anyone guide me how to achieve ?1. Source and Destination Tables are different Name2. Source and Destination Filed names are different3. Source and Destination field type different ... not all the time...need to check source field type is bit and destination field type is tinnyInt4. Check how insert, update and delete will work5. How do we setup the replication when databases are on different servers and replication on different serverEx: DB1 on Server 1, DB2 on server 2 and Replication on Server3Need to check how do we setup the credentials etc ...... |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-10 : 14:32:20
|
| Table names and field names aren't a difficult problem, but are a very bad idea.You can set this in the publication properties.Data type differences...never did that, might fail altogether, might work but fail on certain updates. VERY bad idea.If you're trying to insert data to not-matching tables, better to use an SSIS package for this (or T-SQL script) so you can manage the transformations. |
 |
|
|
asritha
Starting Member
4 Posts |
Posted - 2011-06-15 : 10:31:16
|
| I am new to SSIS.Can you please guide me how to go about using SSIS to achieve the task? Thanks in advance. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-15 : 10:56:21
|
| This is a good place to start.Also, you can use the data import wizard and save the package to see what it generates. |
|
|
|
|
|
|
Replication between 2 databses havin Source and De