locked
SQL Server Management Studio Express - Import Data...? RRS feed

  • Question

  • Hi, I have Microsoft SQL Server Management Studio Express and do not see how I can enable the Import Data... feature which I have seen on the regular Microsoft SQL Server Management Studio version.

    Basically, if I right-click on a database, I'd like to use the Import Data... function which should be found in this menu under the Tasks... item.  The Import Data... menu choice is visible just below the  Generate Scripts... choice in Microsoft SQL Server Management Studio but not in Microsoft SQL Server Management Studio Express.

    Can anybody tell me if this feature is available in the express version.  If not what are my options in order of least cost.  Microsoft SQL Server Management Studio is really beyond my ability to purchase. 

    Thanks for your advice!

    David M. Bennett

     

    Wednesday, June 14, 2006 2:10 PM

Answers

  • SSMS-E does not include import data because Express does not include integration services. Fro development the least cost approach would be to buy developer edition fo about 50USD. For production use you can buy Workgroup Edition
    Wednesday, June 14, 2006 4:52 PM