Search for: Search:

How to import all DNS records from one server to another

How to import all DNS records from one server to another

Hi Everyone, I recently had to do a HUGE import of DNS Records for an internal DNS Server. Here is how we did it.

Part A – Export the DNS records from the source server.

on the source DNS server

1.open DNS managment.

2.right click on the relevant zone->export list

3.save the file , and copy it to the target server.

The output should look like this

in this example i would want to export only the static DNS records, so i will filter column D  and leave only the static records.

Part B – Import the static entries into the target server

1.We will use DNSCMD to import the DNS entries we exported in Part A.
2.Open the file you saved in step A, in Excel
3.Delete any of the rows that you dont need – i left only the static entries.
4.Right click on Colum A and choose “Insert”.
5.Enter DNSCMD in A1 cell and copy it all the way down.
6.Right-click on Column B and choose “Insert”
7.Enter the target DNS Server’s name/FQDN/IP on cell B1  and copy it all the way down
8.Right-click on Column C and choose“Insert”
9.Enter ‘/recordadd on cell C1 and copy it all the way down (need the apostrophe otherwise excel will get angry about the /)
10.Right-click on Column D and choose “Insert”
11.Enter the zone name on cell D1 and copy it all the way down
12.Sort the sheet  by column F and change the records on  this column  to the type you need.
13.replace Host(A) -> A

14.delete column H.
15.save the file as a CSV file and open it on notepad
16.Save the file as a CSV
17.Do a search-replace on , and replace it with a space
18.save the file as bat file. make sure that there is only a  single space between each word:

19.Finally :Use Run as to open a dos command prompt with DNS privilidges in the target domain

 

 

one more note:

if you want to copy the records from a sub-zone the syntax should be slightly different, you need to add to the host name  a dot with  the sub-zone name ,

for example , if i want to add a record for a host named pc01.mysubzone.bb.local , the syntax would be

DNSCMD 192.168.1.22  /recordadd  bb.local  pc01.mysubzone  A 10.150.30.17

 

Report from http://itprofessors.wordpress.com/2012/10/10/how-to-import-all-dns-records-from-one-server-to-another/

BigSurCharles

Charles Love has been working in the IT Support and Consulting field since 1997. Before IT, Charles was working on his FAA A&P Airline Mechanic Certification in Queens, New York. Charles’ first managed services position was in 2001 on Farmingdale, Long Island, back then MSP’s were called Solution Providers. Throughout his career he has provided valuable consulting to various types of customers and technologies throughout North America. Charles started out as the first Big Sur full-time hire of the now rapidly increasing technical support team. As Director of Service and Cloud Operations, Charles’ role includes developing new and streamlined processes for all of Big Sur’s offerings and leading Big Sur’s highly talented team of engineers.


Write a Reply or Comment