Monday, March 19, 2012

export/import database to database?

Hi,
I'm looking for the best way to export a database to another database. Essentially making a copy of it. I need to keep all of the database structure and data. I need a way to do this all programmatically, rather then through the wizard.

Thanks,
~Jamie

Look into SMO it would allow you to handle this programmatically. This is referenced on the SMO forum here...http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=144678&SiteID=1

|||hmm... that seems interesting. I'm not sure if that will help me though. I should have mentioned this earlier, i am using coldfusion. It doesn't look like you can impliment SMO with coldfusion.

No comments:

Post a Comment