SQL Server 2008 Replication

I'm attempting to setup replication between two different schemas within SQL Server 2008, and I'm wondering if it is possible to run replcation with two schemas that are different, and if so what is the best replication type.

I'd be in favor of a periodic SSIS job that moves all your data from one location ot the other. Replication (in the SQL Native Replication sense of the term) is designed for exactly copied schemas in different locations. To put it another way, replication is built to re-play your local transactions against a remote dataset so everything stays in sync - when you change the data layout at the remote location, it can no longer replay the transaction, so you can't use native replication.

To replicate from one table to another of a different layout, you'll need to either roll your own replication (SSIS or a custom SP in a SQL Agent job), or invest in a product that does that kind of thing for you (like Oracle Goldengate).

Long way back, we had to take help from third party tools in order to encrypt and decrypt data. Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…

Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…