Post reply

Queries on different Servers

  • May 14, 2008 at 2:10 pm

    #71593

    Hi,

    I need to move some database from one server to another one. We have a bunch of queries targeting more then one database on the same server, something like this one:

    select * from database.dbo.tablename

    I would like to be able to move the database to another server. If I create a Link Server, I need to review all queries to add the link server in it, like this

    select * from linkserver.database.dbo.tablename

    Is there a way to create a remote database. So I will not have to change my queries.

    Thanks

  • May 14, 2008 at 2:19 pm

    #815535

    I forgot to add that I am in a process of migrating from SQL2000 to SQL2005. I want to see if I can move databases from server sql2000 to sql2005. Our current server has a lot of databases, and I would liewk to migrate them in differents steps.

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

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