Post reply

Import/Export database in SQL Server 2005 EE

  • March 27, 2009 at 4:23 am

    #132513

    Hi,

    I am using SQL Server 2005 Enterprise Edition for most of my developements, including pure client server based application.

    I have a remote server with SS 2k5 Enterprise Edition installed on it; and i used to connect it from my desktop. Everything is working fine but to stuck with the situation when i need to import/export my database.

    SQL Server 2005 Express Edition is not allowed import/export facility!!! Is there any way to overcome this limitation? (otherthan to go for developer or enterprise edition... :-] they are not free..)

    Any idea?

    "Don't limit your challenges, challenge your limits"

  • March 27, 2009 at 5:32 am

    #967318

    I believe the DTSWizard.exe (import export wizard) is in the toolkit (if you are talking about 2005)

    http://www.microsoft.com/downloads/details.aspx?FamilyId=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en

  • March 27, 2009 at 5:50 am

    #967329

    hey, thnks for the link... it's huge in size...

    but though, in description, it doesn't mention about DTSWizard.exe.. what the content is 1) SSMS Express & 2) BIDS (for reporting)..

    R u sure DTSWizard.exe is there? due to very huge size, i hv to ask my network dept to download it for me.. that's y i want to be sure.. :-}

    "Don't limit your challenges, challenge your limits"

  • March 27, 2009 at 5:52 am

    #967333

    well, I wasn't 100%, but I did a quick google search and found this

    http://cfsilence.com/blog/client/index.cfm/2007/1/16/SQL-Server-2005-Express--DTS-Confirmed

  • March 27, 2009 at 6:09 am

    #967349

    Okey...

    so, ball is now in my cort... let me download it...

    and will come with the result...

    "Don't limit your challenges, challenge your limits"

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply