SQL Server Query

By desainad ·
SQL Server query
I have two sql server databases, one in sql server 2k and another in sql server 6.5. The two databases have same business data, but the schemas are different and the names of the tables and columns are different too. One application is in .net that relates to the SQL Server 2k database, another is a PB application that relates to 6.5 database.

What would be a quick resolution to having only one database and having both the apps talk to only that database? I do have a column to column map of the databases. Is there a 'synonym' feature in 2K that I can use or is there any script I can write without having to change a lot of code?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums