Sample Header Ad - 728x90

Microsoft SQL Server Import Export Wizard on Remote SQL Server

0 votes
1 answer
117 views
Is it possible to run the SQL Server Import/Export Wizard purely on a remote server (e.g., from one database to another on the same remote server)? If I setup the source/destination connections in the Wizard on my local machine, I can only enter connections to the remote server as I would make them from my local machine. I cannot enter the connections as the remote server would make them. If I then run the Wizard, it transfers the data via my local machine, even though it would be much faster if the remote server connected directly to the source/destination. For example: - A single SQL Server on a remote machine with two databases: DB1 and DB2. - SSMS on local machine connected to SQL Server on remote machine. - Task: copy (very large) table from DB1 to DB2. - Setup Import/Export Wizard with connections to both tables. - Issue: data transfer via local machine (from DB1 to local machine to DB2). I have looked at the Wizard documentation , but I couldn’t find any description of this issue. Am I missing something? I would guess that most SQL Servers run on some remote machine and not locally.
Asked by Phil C (103 rep)
Jun 26, 2024, 07:19 AM
Last activity: Jun 26, 2024, 08:18 AM