Post reply

How to link tables from one SQL server to another in SQL 2008

  • January 21, 2009 at 6:54 am

    #199087

    Hello, I'm not the database Admin at my company but since I am a native English speaker and he isn't he asked me to post this question here to see if someone has an answer for him.

    Last week we migrated our company database from SQL 2000 to 2008 and using a lot of the good advice here we haven't had many major issues up to now.

    But the move to the new server platform removed all the links between tables in our old company database and our Navision database.

    Now when he tries to reestablish the links so he can remake the views he is only given the opportunity to import and not link the needed tables.

    I hope you can understand what I mean and when and if you hopefully have a solution I'll be able to explain it to him in German 🙂

    Thanks,

    Shawn

  • January 21, 2009 at 7:07 am

    #930304

    Do you still have a backup for the old tables, on a SQL 2000 Format 🙂

  • January 21, 2009 at 7:11 am

    #930310

    Yes, but it should now be a link from SQL 2008 to SQL 2005 (Navision)

    The old SQL 2000 to SQL 2005 (Navision) worked just fine.

    I have the old 2000 database still intact (but offline) what do you suggest?

  • January 21, 2009 at 8:11 am

    #930374

    Hi let me make my self clear, are we talking about linked servers, or relationship between tables

  • January 21, 2009 at 8:22 am

    #930387

    It sounds to me like you had a linked server set up between your SQL2k and SQL2k5 servers. You should create the same linked server setup on the SQL2k8 for all your views and queries to work.

  • January 21, 2009 at 11:31 pm

    #930896

    I am going to try to explain this directly from what my database admin is telling me.

    Company Database reads the data out of selected tables in the Navision database as a (odbc) link and shows it in the Access Frontend (adp). The data remains on the Navision server.

    Before we used the Access Frontend over ODBC to link the two Databases. Now since with 2008 we can no longer use the Access Frontend to influence the Backend and are stuck with the SSMS 2008 we are looking for a way to reestablish the link between the two Databases. SSMS 2008 only gives him the option to import the data, something we do not want to do.

  • January 22, 2009 at 12:18 pm

    #931380

    Hi

    If you connect to your SQL Server 2000 and go under Security / Linked Server, do you have any entry there, perharps something referencing your SQL Server 2005?

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply