"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:...
> To make the connection to an FTP site to
>
> GET = you can use the FTP tasl inside DTS or you can use FTP.exe inside a
> batch file and call through the ExecuteProcess task
> PUT = FTP.exe inside a batch file.
>
> HTH
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:ce83qo$rv3$1$8302bc10@news.demon.co.uk...
> > Hi,
> >
> > I am new to SQL server.
> >
> > I have updated my web site to SQL server (used to use Access
sucessfully)
> >
> > I now need to synchronise both ways -
> > ie some data is created on the server and need putting on the web
> > and some data is created on the web and needs fetching back to the
server.
> >
> > I have played with dts and can move data from access to sql and vice
versa
> > (locally) but can't understand how to make the connection to my ftp.
> >
> > Needless to say I have all the connection info and have verified this is
> > working (ie Dreamweaver connected OK)
> >
> > thanks for any help.
> >
> > NEIL
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OxPhpWKdEHA.3216@TK2MSFTNGP11.phx.gbl...
> Just reread the mail.
>
> Did you actually mean that you wanted to upload a table to an FTP site?
>
> In what format?
>
> Remember SQL Server is not file based.
>
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:...
> > To make the connection to an FTP site to
> >
> > GET = you can use the FTP tasl inside DTS or you can use FTP.exe inside
a
> > batch file and call through the ExecuteProcess task
> > PUT = FTP.exe inside a batch file.
> >
> > HTH
> >
> > --
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > www.konesans.com - Consultancy from the people who know
> >
> >
> > "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> > news:ce83qo$rv3$1$8302bc10@news.demon.co.uk...
> > > Hi,
> > >
> > > I am new to SQL server.
> > >
> > > I have updated my web site to SQL server (used to use Access
> sucessfully)
> > >
> > > I now need to synchronise both ways -
> > > ie some data is created on the server and need putting on the web
> > > and some data is created on the web and needs fetching back to the
> server.
> > >
> > > I have played with dts and can move data from access to sql and vice
> versa
> > > (locally) but can't understand how to make the connection to my ftp.
> > >
> > > Needless to say I have all the connection info and have verified this
is
> > > working (ie Dreamweaver connected OK)
> > >
> > > thanks for any help.
> > >
> > > NEIL
> > >
> > >
> >
> >
>
>

"Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
news:ceb8hm$nqi$1$8302bc10@news.demon.co.uk...
>
>
> Allan
>
> A) I have a SQL table locally which I need to send to my web host's SQL
> server using the ftp address provided.
>
> B) I wish to retrieve specific tables on my web host's SQL server back to
my
> local server for processing.
>
> NEIL
>
>
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:OxPhpWKdEHA.3216@TK2MSFTNGP11.phx.gbl...
> > Just reread the mail.
> >
> > Did you actually mean that you wanted to upload a table to an FTP site?
> >
> > In what format?
> >
> > Remember SQL Server is not file based.
> >
> >
> >
> > --
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > www.konesans.com - Consultancy from the people who know
> >
> >
> > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:...
> > > To make the connection to an FTP site to
> > >
> > > GET = you can use the FTP tasl inside DTS or you can use FTP.exe
inside
> a
> > > batch file and call through the ExecuteProcess task
> > > PUT = FTP.exe inside a batch file.
> > >
> > > HTH
> > >
> > > --
> > > --
> > >
> > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > > www.SQLDTS.com - The site for all your DTS needs.
> > > www.konesans.com - Consultancy from the people who know
> > >
> > >
> > > "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> > > news:ce83qo$rv3$1$8302bc10@news.demon.co.uk...
> > > > Hi,
> > > >
> > > > I am new to SQL server.
> > > >
> > > > I have updated my web site to SQL server (used to use Access
> > sucessfully)
> > > >
> > > > I now need to synchronise both ways -
> > > > ie some data is created on the server and need putting on the web
> > > > and some data is created on the web and needs fetching back to the
> > server.
> > > >
> > > > I have played with dts and can move data from access to sql and vice
> > versa
> > > > (locally) but can't understand how to make the connection to my ftp.
> > > >
> > > > Needless to say I have all the connection info and have verified
this
> is
> > > > working (ie Dreamweaver connected OK)
> > > >
> > > > thanks for any help.
> > > >
> > > > NEIL
> > > >
> > > >
> > >
> > >
> >
> >
>
>

>
> Can you not connect using the IP address and port provided by your hosting
> company to the database?

> You should be able to and once you do that then transferring th table over
> is no more difficult than if the other server were local (except it will
be
> slower)
>

"Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cebgvg$50g$1$8302bc10@news.demon.co.uk...
> >
> > Can you not connect using the IP address and port provided by your
hosting
> > company to the database?
>
> Do you mean create an entry in my list of servers? Maybe this is where i'm
> going wrong. How do I do this? I have tried to - did New Server and then
> Register Server, but it only showed me my local server. This is the point
I
> get confused. Have to admit to using SQLserver for only 2 months now and
all
> at a developmental level, not actual live data (YET)
> N
>
>
>
> > You should be able to and once you do that then transferring th table
over
> > is no more difficult than if the other server were local (except it will
> be
> > slower)
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:u1TRqHadEHA.3412@TK2MSFTNGP11.phx.gbl...
> Ahhhh
>
>
> than it all becomes clearer to me now.
>
> Your hosting company will have given you
>
> An IP address for the SQL Server
> Possibly a port number
> A login name
> A password
>
>
> On your home PC I would do
>
> Start | Run | Cliconfg
>
> Go to aliases and create a TCP IP Alias to the IP address and port you
were
> given
>
> You can now register that name (typing might be required) in EM.
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cebgvg$50g$1$8302bc10@news.demon.co.uk...
> > >
> > > Can you not connect using the IP address and port provided by your
> hosting
> > > company to the database?
> >
> > Do you mean create an entry in my list of servers? Maybe this is where
i'm
> > going wrong. How do I do this? I have tried to - did New Server and then
> > Register Server, but it only showed me my local server. This is the
point
> I
> > get confused. Have to admit to using SQLserver for only 2 months now and
> all
> > at a developmental level, not actual live data (YET)
> > N
> >
> >
> >
> > > You should be able to and once you do that then transferring th table
> over
> > > is no more difficult than if the other server were local (except it
will
> > be
> > > slower)
> > >
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:u1TRqHadEHA.3412@TK2MSFTNGP11.phx.gbl...
> Ahhhh
>
>
> than it all becomes clearer to me now.
>
> Your hosting company will have given you
>
> An IP address for the SQL Server
> Possibly a port number
> A login name
> A password
>
>
> On your home PC I would do
>
> Start | Run | Cliconfg
>
> Go to aliases and create a TCP IP Alias to the IP address and port you
were
> given
>
> You can now register that name (typing might be required) in EM.
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cebgvg$50g$1$8302bc10@news.demon.co.uk...
> > >
> > > Can you not connect using the IP address and port provided by your
> hosting
> > > company to the database?
> >
> > Do you mean create an entry in my list of servers? Maybe this is where
i'm
> > going wrong. How do I do this? I have tried to - did New Server and then
> > Register Server, but it only showed me my local server. This is the
point
> I
> > get confused. Have to admit to using SQLserver for only 2 months now and
> all
> > at a developmental level, not actual live data (YET)
> > N
> >
> >
> >
> > > You should be able to and once you do that then transferring th table
> over
> > > is no more difficult than if the other server were local (except it
will
> > be
> > > slower)
> > >
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:u1TRqHadEHA.3412@TK2MSFTNGP11.phx.gbl...
> Ahhhh
>
>
> than it all becomes clearer to me now.
>
> Your hosting company will have given you
>
> An IP address for the SQL Server
> Possibly a port number
> A login name
> A password
>
>
> On your home PC I would do
>
> Start | Run | Cliconfg
>
> Go to aliases and create a TCP IP Alias to the IP address and port you
were
> given
>
> You can now register that name (typing might be required) in EM.
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cebgvg$50g$1$8302bc10@news.demon.co.uk...
> > >
> > > Can you not connect using the IP address and port provided by your
> hosting
> > > company to the database?
> >
> > Do you mean create an entry in my list of servers? Maybe this is where
i'm
> > going wrong. How do I do this? I have tried to - did New Server and then
> > Register Server, but it only showed me my local server. This is the
point
> I
> > get confused. Have to admit to using SQLserver for only 2 months now and
> all
> > at a developmental level, not actual live data (YET)
> > N
> >
> >
> >
> > > You should be able to and once you do that then transferring th table
> over
> > > is no more difficult than if the other server were local (except it
will
> > be
> > > slower)
> > >
> >
> >
>
>

"Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
news:ced2vp$o9f$1$8302bc10@news.demon.co.uk...
> Another thing:
>
> The web host actually provides stuff I havent used -
>
> as well as host name (mssql06.???.co.uk)
> there is database name (db???)
> and then username (dbo???)
> and password (xyz)
>
> so if I use the host name in the cliconfig and follow with UN and PW, I
> have not used DBname so how can this connect?
>
> Sorry to bombard you, but your help is appreciated.
>
> NEIL
>
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:u1TRqHadEHA.3412@TK2MSFTNGP11.phx.gbl...
> > Ahhhh
> >
> >
> > than it all becomes clearer to me now.
> >
> > Your hosting company will have given you
> >
> > An IP address for the SQL Server
> > Possibly a port number
> > A login name
> > A password
> >
> >
> > On your home PC I would do
> >
> > Start | Run | Cliconfg
> >
> > Go to aliases and create a TCP IP Alias to the IP address and port you
> were
> > given
> >
> > You can now register that name (typing might be required) in EM.
> >
> >
> > --
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > www.konesans.com - Consultancy from the people who know
> >
> >
> > "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> > news:cebgvg$50g$1$8302bc10@news.demon.co.uk...
> > > >
> > > > Can you not connect using the IP address and port provided by your
> > hosting
> > > > company to the database?
> > >
> > > Do you mean create an entry in my list of servers? Maybe this is where
> i'm
> > > going wrong. How do I do this? I have tried to - did New Server and
then
> > > Register Server, but it only showed me my local server. This is the
> point
> > I
> > > get confused. Have to admit to using SQLserver for only 2 months now
and
> > all
> > > at a developmental level, not actual live data (YET)
> > > N
> > >
> > >
> > >
> > > > You should be able to and once you do that then transferring th
table
> > over
> > > > is no more difficult than if the other server were local (except it
> will
> > > be
> > > > slower)
> > > >
> > >
> > >
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:e5QcNqidEHA.3512@TK2MSFTNGP12.phx.gbl...
> You have a login to the server and you are a user in your DB
>
> You connect to the server in QA using your UserName and Pwd
> You will then only see the DBs in the dropdown to which you have
permissions
>
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:ced2vp$o9f$1$8302bc10@news.demon.co.uk...
> > Another thing:
> >
> > The web host actually provides stuff I havent used -
> >
> > as well as host name (mssql06.???.co.uk)
> > there is database name (db???)
> > and then username (dbo???)
> > and password (xyz)
> >
> > so if I use the host name in the cliconfig and follow with UN and PW, I
> > have not used DBname so how can this connect?
> >
> > Sorry to bombard you, but your help is appreciated.
> >
> > NEIL
> >
> >
> >
> > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> > news:u1TRqHadEHA.3412@TK2MSFTNGP11.phx.gbl...
> > > Ahhhh
> > >
> > >
> > > than it all becomes clearer to me now.
> > >
> > > Your hosting company will have given you
> > >
> > > An IP address for the SQL Server
> > > Possibly a port number
> > > A login name
> > > A password
> > >
> > >
> > > On your home PC I would do
> > >
> > > Start | Run | Cliconfg
> > >
> > > Go to aliases and create a TCP IP Alias to the IP address and port you
> > were
> > > given
> > >
> > > You can now register that name (typing might be required) in EM.
> > >
> > >
> > > --
> > > --
> > >
> > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > > www.SQLDTS.com - The site for all your DTS needs.
> > > www.konesans.com - Consultancy from the people who know
> > >
> > >
> > > "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> > > news:cebgvg$50g$1$8302bc10@news.demon.co.uk...
> > > > >
> > > > > Can you not connect using the IP address and port provided by your
> > > hosting
> > > > > company to the database?
> > > >
> > > > Do you mean create an entry in my list of servers? Maybe this is
where
> > i'm
> > > > going wrong. How do I do this? I have tried to - did New Server and
> then
> > > > Register Server, but it only showed me my local server. This is the
> > point
> > > I
> > > > get confused. Have to admit to using SQLserver for only 2 months now
> and
> > > all
> > > > at a developmental level, not actual live data (YET)
> > > > N
> > > >
> > > >
> > > >
> > > > > You should be able to and once you do that then transferring th
> table
> > > over
> > > > > is no more difficult than if the other server were local (except
it
> > will
> > > > be
> > > > > slower)
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>