Client has 2 sites: Site1.co.uk and Site2.co.uk which are totally independant of each other. Each site has a Windows 2003 server (Not SBS though) that handles AD, DNS, WINS, Exchange, etc. Site1 has the main marketing team although site2 also has a smaller team, both teams use the same commercial software - site1 team have 30k records and the software runs on SQL 2005, site2 team have 3k records and the software runs on SQL Server Express edition
They now want to split the marketing team (Currently at site1) and put mostof them at site2. Naturally, they want to move the database to site2 and start to maintain a common database across both sites. The people behind the software say that the 2 databases can be merged although they are not sure yet about the SQL Server/Express issues but in all honesty that's not really my concern!
Enough of the background - should I:
A) Look to create a single AD structure by joining site2 as a subsite of site1 (Can I even do this?). I guess this requires a VPN
B) Leave both sites independant of each other but create a trust to allow them to use a VPN for the shared data
In either case it will be something I have not had to do previously so any tips will be appreciated!
Probably not relevant as I can turn the automatic policy off but site1 uses an underscore character in the email address, site2 uses a period character so I guess creating a single AD structure could confuse their clients having to remember if it is first_last ot first.last