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 |
|
imlodhi
Starting Member
2 Posts |
 Posted - 2011-05-30 : 18:55:35
|
| I have a situation where I need to create a centeral database for multiple frontend applications.e.g.,I have a database "A" is going to be main database and below is the list of expected activities for this database.1. Part of database tables will be populated from a remote server database "B" using transactional replication.2. Few of the tables will be populated from database "C" using migration agent jobs.3. Database "A" will be used to populate frontend website "ABC" using different views and changes made on websites would be written back to database (using updateable views/ stored procedures???? not sure which approach is best)4. Data will be migrated to database "C" from "A" using scheduled jobs for an application running database "C"This is the overall scenario i need to implement. The main purpose is to combine data from differnet databases/sources to one repository i.e., "A" database in this case for ease of use for different puposes.I want to know what are the complexities involved in this process and what are the best practices to implement this approach.Your comments and suggestions in this regard would be much appreciated.Thanks. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-05-31 : 01:30:33
|
| Some general considerations in the scenario you've outlined are:1)Data Model - ensure you use effective naming conventions. As you are moving around data - maintain consistency. Ensure your design is solid2)Consider how you are to split out transactional with reporting data .How you might be using different indexes for different types of queries 3)Look at the location of the databases - will they all be located on one drive- what is your underlying storage subsystem. At minimum ,maintain data|log|tempdb on separate drives. Benchmark the resource requirements of the databases and make decisions based on these resultsJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Central Database for Multiple websites