Home ›
ASP.NET Forums » Data Access » Data Access and ObjectDataSource Control » Copy tables from one database to another?

Copy tables from one database to another?

Last post 05-16-2008 2:59 PM by ArminStockner. 1 replies.

Sort Posts:

  • Hmm [^o)] Copy tables from one database to another?

    05-16-2008, 2:03 PM
    • Loading...
    • jeppe_r
    • Joined on 12-31-2007, 12:37 AM
    • Denmark
    • Posts 143

    Hello there,

    Is there an easy way to copy alle tables from one database to another?
    I have not really tried to create tables or copy or something like that, so i dont even know if its possible?

    Hope some of you can help me,

    ----------------
    Regards,
    Jeppe Richardt

  • Re: Copy tables from one database to another?

    05-16-2008, 2:59 PM
    Answer

    Hey you could use SQL Bulkcopy:

    http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy(VS.80).aspx 

    Please: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue.
Page 1 of 1 (2 items)
RSS Available

Advertise on ASP.NET

About this Site

Microsoft Communities
Page view counter