Hi frineds, We are using multiple databases (SQL Server) in our application (J2EE) . Our connection is always to the main DB & Our client wants us to use VIEWS whenever we update or insert into the other databases. Is this a recommended way? Will there be performance impact owing to this? Their point is, it gives them the freedom to change the name or schema of the other DBs and allowes our application to be not tightly coupled to the other DB params. Thanks in advance
Sorry vvkp, I haven't read your post carefully first time I posted the answer. Are all your dbs on the same database server? For schema changes stored procedures or views for select and procedures for update/insert/delete is better solution. However if they want to be able to change database names, I am not quite sure...
