Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




Create queries of database tables with its data (Microsoft SQL Server Database Publishing Wizard 1.1 )

Some time you may have situation that you need to import the data from sql server. If you are using enterprise edition or developer edition, then it have facility to import the data, but if you are using sql express edition, there is no inbuilt functionality, For this purpose you may use the Data Publishing Wizard. Below are the steps to install this software utility,

Sql Server 2005 Express edition: Download the software from below link and install.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a

If you have sql 2008 express edition then it is necessary to install some small packs before you start installation.

Install Microsoft SQL Server Native Client (for 2005) Size : (3516 KB - 32 bit) and (6403 KB - 64 bit) - go on http://www.microsoft.com/downloads/en/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en page

- search "SQL Server Native Client " and install x86 if you are running on 32 bit or x64 if you are running 64 bit

After that install Microsoft SQL Server 2005 Management Objects Collection Size (9529 KB - 32 bit) and (14963 KB - 64 bit)

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en#XMO

After step a and b, now you are ready to install Database publishing wizard

Run the Microsoft SQL Server Database Publishing Wizard 1.1 msi file (DatabasePublishingWizard.msi, size : 2.1 MB)

Share this article   |    Print    |    Article read by 3569 times
Author:
Rohit kakria
I am software developer, moderator of xpode.com
Related Articles: No related article
Related Interview Questions: No related interview question