Replication - 2005 Standard to Express

[ldoodle]

Hi, I need a one-way replication from our Standard server to Express Server.

We have 2 SQL 2005 Servers (one Standard, one Express). The Standard server contains our Management Information System, which contains all our student details. The Express one contains our own developed database.

The Express database contains the following fields that I need replicating
from the Standard server:

AdNo
StudentInitials
StudentFirstName
StudentLastName
MentorGroup
SoL
Year
Gender
Address
A2LPoints

Now the A2LPoints field doesn't exist on the Standard server, so this will
need creating for every NEW record (existing records already have this and
must not change) and a default value of 20 to be put in.

Also, the Address field on the Standard server uses Char(10) as it's address
line seperator, and I would ideally like this changed to a ";" character for
ease of using the ASP Replace function in my code, but this is not essential.

Is this do-able...?

Thanks very much/...