hi
I have a primary database with normalization(OLTP).i am planning to create a stand by database in another server. i use Transactional replication for data tranfer between these two databases. i have a question on this. in the primary database we have many tables, but in standby database we have only 15 tables which are used to generate reports. is it necessary to maintain relation ship between tables in standby database i.e. foreign keys? and any other things i need to do for reducing the performance issues for generating reports.
please guide me how to proceed further
Thanks
Rock..:-)