asked on

Import DNS txt file into Windows DNS Server

In my company we have thousands of switches and routers with unique host names and I have list with all the host names and IP addresses that are in only 1 servers host file. I wanted to import this host file into my 2 Windows Domain Controllers running DNS. How do I import a TXT or CSV (either or) file into a Windows DNS server?

sk_raja_raja

ref this post,
https://www.experts-exchange.com/questions/21959011/Import-DNS-records.html

Naga Bhanu Kiran Kota

Hi,

i think this post on MS can help you. This post talks about reverse address zone but you can get help for you text file by using the DNS import export tool

http://blogs.msdn.com/richpec/archive/2008/08/24/how-to-consolidate-many-reverse-dns-zones-into-fewer-larger-reverse-dns-zones.aspx

or use this which talks about importing text file to unix DNS (BINDS) and then importing that to windows dns server.

http://www.eggheadcafe.com/forumarchives/windowsserverdns/Aug2005/post23676167.asp

bhanu

ASKER CERTIFIED SOLUTION

Chris Dent

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Naga Bhanu Kiran Kota

Hi Chris

That seems to be the easiest way. Hope this would be helpful to the asker too.

bhanu

Ensilence

ASKER

Chris,

I will take a look at what the DNSCMD is and how it can help me. Right now what I am working with is a users host file from the drivers\etc dir and has all the host names and IPs populated. Like:
10.45.1.254 Site45rtr01
10.46.1.254 Site46rtr01
10.47.1.254 Site47rtr01
10.48.1.254 Site48rtr01
10.49.1.254 Site49rtr01
10.50.1.254 Site50rtr01
10.52.1.254 Site51rtr01

My Excell skills are old but you can teach this dog new tricks. I will look at what you suggested about using Excel but I am wondering if there was an easier way to import this lame TXT file list into DNS and populate the A records etc. I am currently using or looking at dnsmgmt console. Kind of clueless to this function I want to perform. Limited research online had suggested editing a .DNS file or something...? Any more words would likely be greatly appreciated.

Chris Dent

There's nothing simple in the DNS console that will let you I'm afraid.

If your zone were not AD Integrated you would have a text file for the zone file, that's the one with the .dns extension it would have hidden in %SystemRoot%\System32\DNS\. AD Integration moves that data into Active Directory itself as objects we won't be able to write directly.

We can, of course, write a script to rip apart the text file and construct the relevant records for us. And we could use WMI to add those in, it's not difficult if you're experienced with the interface at all.

However, using DNSCMD and the method described above will give you a much easier view of the changes if you aren't familiar with the scripting interfaces (either VbScript or PowerShell if I'm doing it).

I'm more than happy to show you the scripted methods if you prefer those :)

Chris