Discussion Locked

SQL Server query

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

1 reply

by deepsand

The "Discussion" forum is for matters of general discussion, not specific problems in search of a solution.

Post problems such as this to the "Question" forum, rather than the "Discussion" forum. There are those who specifically seek out problems in need of a solution, and that's where they go to look for such.

Additionally there are the benefits that:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The revised TR makes it quite difficult to find both "Discussions" and "Questions" that have not had a fairly recent post, owing to some functions comingling them in the listings. By keeping each type in their respective forums, it is easier for all to find what they are looking for.

This discussion is closed to new replies.