inetserver asp db: I am in the process of merging approximately 5 databases for
development into 1 final database but will for the new merged copy to
go live I need to copy over all the data on a live server using a
single asp script.

In access I can do a copy and paste using structure and data.

How can I do this using ASP?
I have researched using a VBA and it doesnt fit with my requirements.
I will need to set up IIS using the script at the same time, which is
impossible to do with a VBA.

The problem with creating and populating simply i need the autonumbers
to remain the same.

I know that I previously posted a similar issue but that route (VBA)
didn't prove to be a fruitful endevour. So my understanding is that I
should start a new topic. To make it easier to follow

Thanks for your help

MGREENWAY

[quoted text, click to view]

It would help if you outlined the requirements that VBA does not meet. You
may be wrong about this ... I am not aware of anything a vbscript script can
do that cannot be done via VBA


[quoted text, click to view]

Why? And what setup of IIS are you talking about that can be done via an ASP
page? The abilities of an asp page to do any "IIS setup" are limited (and
rightfully so). IIS would need to be "setup" correctly in the first place
BEFORE an asp page could run, if I am interpreting what you mean by "setup"
correctly.

[quoted text, click to view]

Which makes TransferDatabase ideal for you.

However, the first link I posted was to a VBA procedure that used ADOX to
create the tables and ADO recordsets to move the data. Clunky and slow, but
easily translatable to vbscript [1]. Could you explain why this oes not meet
your requirement?

[quoted text, click to view]

No, starting a new thread on the same topic will make the conversation
harder to follow, especially if someone replies to your first thread,
resulting in two threads on the same topic. But it's not a huge faux pas.

Bob Barrows

[1] 1. all variables are variants in vbscript, so get
rid of all the occurrences of "as <datatype>"
2. Change "Set <variable> = New <class>" to
"Set <variable> = createobject("<class>")
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"