Hi Regan, Have a look at the Maint_DNSFiles as that is the stored procedure that controls exporting the zone files.
There is another procedure DNS_ListDomainsForExport which will give you a list of domains that you would need to recreate. So, I would loop through this list adding a new ObjectLog entry saying the domain was updated and then fire the Maint_DNSFiles procedure using the following query: --- exec Proc_ActivateProcedure 300 --- Note: the value 300 here corresponds to the Maint_DNSFiles procedure listed in the procedures table. You could speed this up by using the DNS_Zone_ChangeStatus stored proc, by calling it once for each domain in the DNS_ListDomainsForExport procedure. The query you would use is: --- EXEC DNS_Zone_ChangeStatus @DomainId, 1, 1, 0 --- Obviously @DomainId is the DomainId returned by the DNS_ListDomainsForExport, the other parameters set the status to InDNS, write a log entry and set the procedure to return a value. Regards, Suneel. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Regan Kingsbury Sent: Friday, April 22, 2005 1:53 PM To: [email protected] Subject: [Rodopi] DNS update info: Hi group, I was wondering if anyone knows how to get Rodopi to regenerate all the zone records for DNS. I'm upgrading to Bind 9 and need to change the format a bit in all the zone records. I figure I can update the zone records and serial numbers in SQL, but I don't think that will upload all the new zone records to my nameservers. I don't have a test bed, so I'd like a second opinion before I take the plunge:-P Thanks for any help anyone can give me. Regan Kingsbury [EMAIL PROTECTED] -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005 --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com --------------------- --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
