February 11, 2009 at 3:58 am
not sure if we can alias a database, but with the method explained earlier in this post as they are just two tables you can alias those two tables and your work would be done.
Sriram
February 11, 2009 at 4:39 am
Sri,
Thats not solved. If i am creating the synonyms i have to change the database name in my application connection string. (But thats not possible for me).
- ramesh.p
February 12, 2009 at 2:08 pm
Try this:
Move the tables from the original databases to your "Something" database
Create synonyms for the tables in the original databases pointing to the the tables in Something
Your original databases will contain nothing but synonyms, and all of your tables will be consolidated in a single database.
February 12, 2009 at 2:22 pm
Brilliant.
February 26, 2016 at 7:34 am
I haven't tried this, but thought you might want to.
Leave the old database in place. I know you have moved the tables to a new DB.
Create Views in the old database which point to the tables in the new database. Give the views names which the application wants.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply