Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
din112
Starting Member
6 Posts |
 Posted - 2005-03-04 : 05:35:29
|
| Hi,I wonder if someone can help.I am attempting to run two servers, one old sql 7 server and one new sql 2000 server. I have a number of databases on the sql 7 server, but the ones I need help with are DB1 and DB2. The problem I have is that I have an application that accesses data in DB1 and DB2. DB2 will be moved to a sql 2000 server and DB1 will stay where it is on the sql 7 server. DB1 uses 'views' to access data in DB2. How can I make DB1 point to DB2, when DB2 will be stored on a new sql 2000 server? I would like to just be able to modify the ‘views’ in DB1.I would greatly appreciate any help.SQL Level: NoviceDin |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-04 : 07:12:43
|
| Create a linked server on the v7 server to the v2000 server.Now change the views that point to DB2 to use the 4 part name.This will work but will have to move the data from one server to the other to service joins so may take a long time (and I mean a very long time) to action queries.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
din112
Starting Member
6 Posts |
Posted - 2005-03-04 : 09:57:34
|
| Thank you for that.I think i will have to put up with the slow speed.After some more research i have found the following pages that should guide me through linked servers and four-part name:[url]http://www.databasejournal.com/features/mssql/article.php/3085211[/url][url]http://www.informit.com/articles/article.asp?p=21644&redir=1[/url][url]http://www.windowsitpro.com/SQLServer/Article/ArticleID/8992/8992.html [/url]I thought someone else might find it useful.Din |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-04 : 15:31:19
|
Using the linked server may cause severe performance problems if you are joining large tables across servers. Before you move the databases, you should look at all of these points in your applicastion.If the performance is not acceptable, you may have to make changes like replicating data between servers, or changing your procedures to optimize for a query against a remote server with OPENROWSET for example.quote:
Originally posted by din112
Thank you for that.I think i will have to put up with the slow speed.After some more research i have found the following pages that should guide me through linked servers and four-part name:[url]http://www.databasejournal.com/features/mssql/article.php/3085211[/url][url]http://www.informit.com/articles/article.asp?p=21644&redir=1[/url][url]http://www.windowsitpro.com/SQLServer/Article/ArticleID/8992/8992.html [/url]I thought someone else might find it useful.Din
CODO ERGO SUM |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-04 : 15:38:16
|
| When I say slow I'm talking about possibly hours if you join large tables.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Sql 'view' - new location