[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

any way to export file in SQL Data base programatically using VC++

can any one tell me is there any way to export or import a file from or to SQL SERVER data base programatically using VC++.
like in VB we use DTS to import and export in SQL Sertver
thanx
ult
0
Ultpak
Asked:
Ultpak
  • 4
  • 2
1 Solution
 
ambienceCommented:
why not use the same DTS in VC ?
0
 
UltpakAuthor Commented:
thanx for replying.
but how to use.
that is not a com component.
that is a feature of VB.
but how in VC, i have no idea.
0
 
ambienceCommented:
In my humble opinion DTS is a full-blown COM application, which resides typically in

<<Microsoft SQL Server>>\80\Tools\Binn\dtspkg.DLL

<<Microsoft SQL Server>> is where you installed SQLServer. You can use COM object viewer to check for interfaces and objects it supports, also you can try out a quick application in VB.

Of particular interest is the TransferObjectsTask interface exposed by DTSTransferObjectsTask, i think this is what can solve your problem.

It has methods that let you specify the source and target of transfer etc.

Hope this helps
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
ambienceCommented:
The TransferObjectsTask object allows you transfer one or more Microsoft® SQL Server™ objects between source and destination databases. An object can represent:

·     A table, or table data.
·     A view.
·     A referential integrity constraint.
·     A stored procedure.
·     An index.
·     A default or a rule.
·     A user-defined data type.

In addition, you can transfer all users or all logins (roles) for the source database. You can also transfer all objects dependent on the requested objects.

Note   The source and destination must both be Microsoft SQL Server version 7.0 or later databases.
0
 
ambienceCommented:
did that help ?
0
 
UltpakAuthor Commented:
still i could't check.
iwill check soon.
hope it will work..
thanx for all u did  for me.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now