Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting Linked Server to SQL Database

Status
Not open for further replies.
Linguinut

Linguinut

Programmer
Feb 19, 2003
4
0
0
US
I have numerous stored procedures using the OPENQUERY method to select/insert/update data within a linked server. The application/database I am connecting to is a BTRIEVE database. Recently, I purchased an upgrade of the application so that it will run on SQL Server rather than BTRIEVE (a very welcome upgrade). The problem I have is with all of the statements that have been written using the linked server. How do I gracefully update all of the stored procedures and other TSQL scripts to use the new database? Has anyone ever done this? If I must do it proc by proc, then I will be in trouble. Hundreds exist and I cannot have the system down more than a day. Any insight and direction would be much appreciated! Linguinut
------------------
Bill Cunnien
ConBrio Consulting
 
Status
Not open for further replies.

Similar threads

V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
311
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
273
pjw001
pjw001
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
188
Mike Lewis
Mike Lewis
Cpreston
  • Question
Seconds to minutes 2
Replies
5
Views
380
Chris Miller
Chris Miller
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
322
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top