I need to create a table and populate its data, including about 100 icon
files stored in IMAGE columns. This will be part of an install that
creates or updates an existing database at a customer site.

Whats the best way to accomplish this via DTS? Since I will not have
access to the remote SQL Server, but I will have dbo connection info
etc, how can I move the data in my existing master copy of the database
to a temporary transportable structure that can then be imported into
the target SQL Server?

I would rather avoid replication and publish subscribe complications if
possible.

Any help would be appreciated.

Robert Porter

Hello,

I am not clear the meaning of "Since I will not have access to the remote
SQL Server, but I will have dbo connection info". Do you have a user
account that has the permission to access the remote SQL server?

Generally, the connection information includes the user name and password
which can be used to access the remote server. If you have the user name
and password on the remote server, you can create a DTS package to export
data by using the "DTS import/export wizard".

I have tested the issue on my side by using the "DTS import/export wizard"
to export the data in Employees to another computer in the same domain.
Because the Employees table in the northwind database has an image column.
I can perform this successfully.

If you want to move SQL Server databases to a new location, it is suggest
that you refer to the following articles:

Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default...B;EN-US;224071

I hope the information is helpful.


Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Ah, sorry. I can DTS data between SQL servers all day long, no problem.
What I mean is I need to find a way to get the data into a database that
I am not connected to. i.e. I have a program that we give new
customers that builds the database and it's tables, and populates some
static data etc. I use scripts to accomplish this, along with text files
containing the "starter" data. What I can't figure out how to do is get
the actual images that I need to populate into the new database at a
customer site into the equivalent of a text file like I use for data.

The user (customer) supplies my scripts (A DTS package contained in a VB
executable.) with the necessary connection info at runtime. That's what
I mean by I don't have access to the server directly. I can't "connect"
the 2 servers since we have several thousand customers etc.

What I was hoping was there was a way of exporting the data including
the images, into some intermediate storage format that I could then
include in my installation and load the target table.

Cheers,

Sophie Guo [MSFT] wrote:

Is the data unque for a customer or is it a starter pack of info for your
database and every customer gets the same. If this is the case then as
suggested load a template DB with ONLY this information and back it up (or
detach it). You then distribute this with whatever else their is and you
can build a little UI that tells the install routine where to find the files
and where to put them.

Short of that I am unsure as to what you mean.

You can still distribute a DTS package and export files and have the cutomer
run them easily enough.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Robert Porter" <rhysliam (AT) noemail (DOT) nospam> wrote