2

I am working through the process of migrating a SQL Server 2014 DB to AWS Redshift. I have converted the schema and provisioned a PostgreSQL Redshift instance. Now in AWS-DMS->Create Migration->Database endpoints->Connect source and target database endpoints I am not clear on the following: 

Server name: ???

What do I need to specify for AWS to see this? My SQL Servername is 'SERVERNAME'. But I presume AWS would need an IP address of my machine as well? Also - I have not opened the Server up for internet access - it is a local install behind a firewall. How should I go about allowing AWS to access it?

Then for the target database connection details:

Server name: ???

Is this the full endpoint or just the server name without the ...amazon.com extension?

Paul White ♦
95.4k30 gold badges440 silver badges689 bronze badges
asked Oct 30, 2016 at 1:42

1 Answer 1

3

The network address of a server instance (its server network address or Endpoint URL) contains the port number of its endpoint, as well as the system and domain name of its host computer. The port number uniquely identifies a specific server instances.

You can try for example below format as we use for Database Mirroring :

TCP://srv5.corp.abc.com:5022

For your reference:

Paul White ♦
95.4k30 gold badges440 silver badges689 bronze badges
answered Oct 30, 2016 at 2:09
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.