Using query to copy data from one DASP db to another

[blueprintpm]

I have 2 databases with DASP. I need a subset of the first database to transfer into the second on a weekly basis. I have tried using Import/Export with a query to do this, but I get the error that I don't have permissions to do it. Is there a way to do what I need without copying the entire table and then subsetting from it?? Thanks for any help or insight!

[joelnet]

There should be a way to do this. If you add the same "additional user" to both databases, you should be able to perform a SELECT-INSERT to transfer the data.

not sure about dts.


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

[blueprintpm]

Joel: DASP won't let me add the same additional user to both. It returns error message: "*User name already exists". Any other suggestions? I'll try anything!

Ali Ibarguen
BluePrint PM, LLC
blueprintpm.com

[Aristotle]

Here's the KB article on how to assign another user to your SQL 2000 database. This assumes of course that your 2 databases are from the same hosting account, which means that they're on the same SQL server.

http://kb.discountasp.net/article.aspx?id=10343

Aristotle

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)