We have a small sqlserver express database that is hosted. It seems
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.
I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.
Is there a simple way to do this on my own, or will I be calling the
hosting company?
Hi
Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.
John
"cowznofsky" <jhcorey@.yahoo.com> wrote in message
news:953cf302-8373-4f4c-9e3e-6d81eedb82ec@.s12g2000prg.googlegroups.com...
> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
> looking to copy a database.
> I suppose one option would be to get a copy of the physical files from
> the hosting company. I haven't looked into that yet.
> I have an SS2000 database and tried to use DTS, but it wouldn' t work
> with Express.
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?
Showing posts with label express. Show all posts
Showing posts with label express. Show all posts
Friday, March 9, 2012
Looking to copy from hosted server to sqlserver express
We have a small sqlserver express database that is hosted. It seems
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.
I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.
Is there a simple way to do this on my own, or will I be calling the
hosting company?Hi
Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.
John
"cowznofsky" <jhcorey@.yahoo.com> wrote in message
news:953cf302-8373-4f4c-9e3e-6d81eedb82ec@.s12g2000prg.googlegroups.com...
> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
> looking to copy a database.
> I suppose one option would be to get a copy of the physical files from
> the hosting company. I haven't looked into that yet.
> I have an SS2000 database and tried to use DTS, but it wouldn' t work
> with Express.
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.
I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.
Is there a simple way to do this on my own, or will I be calling the
hosting company?Hi
Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.
John
"cowznofsky" <jhcorey@.yahoo.com> wrote in message
news:953cf302-8373-4f4c-9e3e-6d81eedb82ec@.s12g2000prg.googlegroups.com...
> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
> looking to copy a database.
> I suppose one option would be to get a copy of the physical files from
> the hosting company. I haven't looked into that yet.
> I have an SS2000 database and tried to use DTS, but it wouldn' t work
> with Express.
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?
Looking to copy from hosted server to sqlserver express
We have a small sqlserver express database that is hosted. It seems
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.
I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.
Is there a simple way to do this on my own, or will I be calling the
hosting company?Hi
Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.
John
"cowznofsky" <jhcorey@.yahoo.com> wrote in message
news:953cf302-8373-4f4c-9e3e-6d81eedb82ec@.s12g2000prg.googlegroups.com...
> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
> looking to copy a database.
> I suppose one option would be to get a copy of the physical files from
> the hosting company. I haven't looked into that yet.
> I have an SS2000 database and tried to use DTS, but it wouldn' t work
> with Express.
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?
to make more sense to take care of it on our own machine, so I'm
looking to copy a database.
I suppose one option would be to get a copy of the physical files from
the hosting company. I haven't looked into that yet.
I have an SS2000 database and tried to use DTS, but it wouldn' t work
with Express.
Is there a simple way to do this on my own, or will I be calling the
hosting company?Hi
Your hosting company should be able to backup the database and allow you to
FTP it, if this is possible it would be the quickest solution for even a
modest size database! You can detach/attach the database if you have access
to the web admin tools and ftp http://support.microsoft.com/kb/314546 should
help you.
John
"cowznofsky" <jhcorey@.yahoo.com> wrote in message
news:953cf302-8373-4f4c-9e3e-6d81eedb82ec@.s12g2000prg.googlegroups.com...
> We have a small sqlserver express database that is hosted. It seems
> to make more sense to take care of it on our own machine, so I'm
> looking to copy a database.
> I suppose one option would be to get a copy of the physical files from
> the hosting company. I haven't looked into that yet.
> I have an SS2000 database and tried to use DTS, but it wouldn' t work
> with Express.
> Is there a simple way to do this on my own, or will I be calling the
> hosting company?
Looking for Vedio Training
Any online vedio training for SQL Server 2005/2005 Express available?
It's just a faster way to learn new features.
It's just a faster way to learn new features.
ThanksI'm not aware of specific training videos. There are, however, many on-demand web casts available for SQL Server 2005. Have you looked at any of these?
For a listing of web casts, see http://www.microsoft.com/events/AdvSearch.mspx?EventsAndWebcastsControlName=As1%3AAdvSrc&As1%3AAdvSrc%3AAudienceID=0&As1%3AAdvSrc%3AProductID=9f07f9cc-c308-4ebf-a4e9-2b8530ab1ea8&As1%3AAdvSrc%3AEventType=OnDemandWebcast&As1%3AAdvSrc%3ACountryRegionID=en%7CUS%7CUnited+States&StateProvinceID=0&As1%3AAdvSrc%3ATimeframeID=-1&As1%3AAdvSrc%3ASearchFilter=%C2%A0+Go+%C2%A0&PageNumber=2
Regards,|||Thank you, gaile:
It may not 100% matched what I am looking for. But there are many useful topics from your links. It helps.
Thank you.
Darren L.|||
Hope this helps it's been great for me...This website has a lot of cheap video series on subjects from programing and office software.
http://www.sqlservertutorials.com/
Looking for Vedio Training
Any online vedio training for SQL Server 2005/2005 Express available?
It's just a faster way to learn new features.
It's just a faster way to learn new features.
ThanksI'm not aware of specific training videos. There are, however, many on-demand web casts available for SQL Server 2005. Have you looked at any of these?
For a listing of web casts, see http://www.microsoft.com/events/AdvSearch.mspx?EventsAndWebcastsControlName=As1%3AAdvSrc&As1%3AAdvSrc%3AAudienceID=0&As1%3AAdvSrc%3AProductID=9f07f9cc-c308-4ebf-a4e9-2b8530ab1ea8&As1%3AAdvSrc%3AEventType=OnDemandWebcast&As1%3AAdvSrc%3ACountryRegionID=en%7CUS%7CUnited+States&StateProvinceID=0&As1%3AAdvSrc%3ATimeframeID=-1&As1%3AAdvSrc%3ASearchFilter=%C2%A0+Go+%C2%A0&PageNumber=2
Regards,|||Thank you, gaile:
It may not 100% matched what I am looking for. But there are many useful topics from your links. It helps.
Thank you.
Darren L.|||
Hope this helps it's been great for me...This website has a lot of cheap video series on subjects from programing and office software.
http://www.sqlservertutorials.com/
Monday, February 20, 2012
Looking for how to for SQLexpress
I recently installed SQL express on my winXP machine at home... Installed
and configured IIS as requested. I have created a simple table for testing
but cannot establish a DSN connection using either SQL or SQL Native driver
It mentioned something about allowing remote connections, but that feature
is turned on.. so not sure what else i need to configure to allow me to
connect so i can start testing some things out..
any sites or even books i can take a look at to complete this would be
great.Hi Daniel
"Daniel" wrote:
> I recently installed SQL express on my winXP machine at home... Installed
> and configured IIS as requested. I have created a simple table for testing
> but cannot establish a DSN connection using either SQL or SQL Native drive
r
> It mentioned something about allowing remote connections, but that feature
> is turned on.. so not sure what else i need to configure to allow me to
> connect so i can start testing some things out..
> any sites or even books i can take a look at to complete this would be
> great.
>
A remote connection should only be needed if you are trying to access your
SQL Express instance from another machine. It can be changed by using the th
e
Surface Area Configuration Tool SQLSAC.exe see previous post
http://tinyurl.com/23dum6 for links on this.
John|||I figured as much... when i installed it i took all the defaults and didnt
change anything.. but i will try this later tonight...
thanks for the reply.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:75A3F905-C157-4283-A407-3DA7BA72A7D7@.microsoft.com...
> Hi Daniel
> "Daniel" wrote:
>
> A remote connection should only be needed if you are trying to access your
> SQL Express instance from another machine. It can be changed by using the
> the
> Surface Area Configuration Tool SQLSAC.exe see previous post
> http://tinyurl.com/23dum6 for links on this.
> John
and configured IIS as requested. I have created a simple table for testing
but cannot establish a DSN connection using either SQL or SQL Native driver
It mentioned something about allowing remote connections, but that feature
is turned on.. so not sure what else i need to configure to allow me to
connect so i can start testing some things out..
any sites or even books i can take a look at to complete this would be
great.Hi Daniel
"Daniel" wrote:
> I recently installed SQL express on my winXP machine at home... Installed
> and configured IIS as requested. I have created a simple table for testing
> but cannot establish a DSN connection using either SQL or SQL Native drive
r
> It mentioned something about allowing remote connections, but that feature
> is turned on.. so not sure what else i need to configure to allow me to
> connect so i can start testing some things out..
> any sites or even books i can take a look at to complete this would be
> great.
>
A remote connection should only be needed if you are trying to access your
SQL Express instance from another machine. It can be changed by using the th
e
Surface Area Configuration Tool SQLSAC.exe see previous post
http://tinyurl.com/23dum6 for links on this.
John|||I figured as much... when i installed it i took all the defaults and didnt
change anything.. but i will try this later tonight...
thanks for the reply.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:75A3F905-C157-4283-A407-3DA7BA72A7D7@.microsoft.com...
> Hi Daniel
> "Daniel" wrote:
>
> A remote connection should only be needed if you are trying to access your
> SQL Express instance from another machine. It can be changed by using the
> the
> Surface Area Configuration Tool SQLSAC.exe see previous post
> http://tinyurl.com/23dum6 for links on this.
> John
Looking for how to for SQLexpress
I recently installed SQL express on my winXP machine at home... Installed
and configured IIS as requested. I have created a simple table for testing
but cannot establish a DSN connection using either SQL or SQL Native driver
It mentioned something about allowing remote connections, but that feature
is turned on.. so not sure what else i need to configure to allow me to
connect so i can start testing some things out..
any sites or even books i can take a look at to complete this would be
great.Hi Daniel
"Daniel" wrote:
> I recently installed SQL express on my winXP machine at home... Installed
> and configured IIS as requested. I have created a simple table for testing
> but cannot establish a DSN connection using either SQL or SQL Native driver
> It mentioned something about allowing remote connections, but that feature
> is turned on.. so not sure what else i need to configure to allow me to
> connect so i can start testing some things out..
> any sites or even books i can take a look at to complete this would be
> great.
>
A remote connection should only be needed if you are trying to access your
SQL Express instance from another machine. It can be changed by using the the
Surface Area Configuration Tool SQLSAC.exe see previous post
http://tinyurl.com/23dum6 for links on this.
John|||I figured as much... when i installed it i took all the defaults and didnt
change anything.. but i will try this later tonight...
thanks for the reply.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:75A3F905-C157-4283-A407-3DA7BA72A7D7@.microsoft.com...
> Hi Daniel
> "Daniel" wrote:
>> I recently installed SQL express on my winXP machine at home... Installed
>> and configured IIS as requested. I have created a simple table for
>> testing
>> but cannot establish a DSN connection using either SQL or SQL Native
>> driver
>> It mentioned something about allowing remote connections, but that
>> feature
>> is turned on.. so not sure what else i need to configure to allow me to
>> connect so i can start testing some things out..
>> any sites or even books i can take a look at to complete this would be
>> great.
> A remote connection should only be needed if you are trying to access your
> SQL Express instance from another machine. It can be changed by using the
> the
> Surface Area Configuration Tool SQLSAC.exe see previous post
> http://tinyurl.com/23dum6 for links on this.
> John
and configured IIS as requested. I have created a simple table for testing
but cannot establish a DSN connection using either SQL or SQL Native driver
It mentioned something about allowing remote connections, but that feature
is turned on.. so not sure what else i need to configure to allow me to
connect so i can start testing some things out..
any sites or even books i can take a look at to complete this would be
great.Hi Daniel
"Daniel" wrote:
> I recently installed SQL express on my winXP machine at home... Installed
> and configured IIS as requested. I have created a simple table for testing
> but cannot establish a DSN connection using either SQL or SQL Native driver
> It mentioned something about allowing remote connections, but that feature
> is turned on.. so not sure what else i need to configure to allow me to
> connect so i can start testing some things out..
> any sites or even books i can take a look at to complete this would be
> great.
>
A remote connection should only be needed if you are trying to access your
SQL Express instance from another machine. It can be changed by using the the
Surface Area Configuration Tool SQLSAC.exe see previous post
http://tinyurl.com/23dum6 for links on this.
John|||I figured as much... when i installed it i took all the defaults and didnt
change anything.. but i will try this later tonight...
thanks for the reply.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:75A3F905-C157-4283-A407-3DA7BA72A7D7@.microsoft.com...
> Hi Daniel
> "Daniel" wrote:
>> I recently installed SQL express on my winXP machine at home... Installed
>> and configured IIS as requested. I have created a simple table for
>> testing
>> but cannot establish a DSN connection using either SQL or SQL Native
>> driver
>> It mentioned something about allowing remote connections, but that
>> feature
>> is turned on.. so not sure what else i need to configure to allow me to
>> connect so i can start testing some things out..
>> any sites or even books i can take a look at to complete this would be
>> great.
> A remote connection should only be needed if you are trying to access your
> SQL Express instance from another machine. It can be changed by using the
> the
> Surface Area Configuration Tool SQLSAC.exe see previous post
> http://tinyurl.com/23dum6 for links on this.
> John
Looking for how to for SQLexpress
I recently installed SQL express on my winXP machine at home... Installed
and configured IIS as requested. I have created a simple table for testing
but cannot establish a DSN connection using either SQL or SQL Native driver
It mentioned something about allowing remote connections, but that feature
is turned on.. so not sure what else i need to configure to allow me to
connect so i can start testing some things out..
any sites or even books i can take a look at to complete this would be
great.
Hi Daniel
"Daniel" wrote:
> I recently installed SQL express on my winXP machine at home... Installed
> and configured IIS as requested. I have created a simple table for testing
> but cannot establish a DSN connection using either SQL or SQL Native driver
> It mentioned something about allowing remote connections, but that feature
> is turned on.. so not sure what else i need to configure to allow me to
> connect so i can start testing some things out..
> any sites or even books i can take a look at to complete this would be
> great.
>
A remote connection should only be needed if you are trying to access your
SQL Express instance from another machine. It can be changed by using the the
Surface Area Configuration Tool SQLSAC.exe see previous post
http://tinyurl.com/23dum6 for links on this.
John
|||I figured as much... when i installed it i took all the defaults and didnt
change anything.. but i will try this later tonight...
thanks for the reply.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:75A3F905-C157-4283-A407-3DA7BA72A7D7@.microsoft.com...
> Hi Daniel
> "Daniel" wrote:
> A remote connection should only be needed if you are trying to access your
> SQL Express instance from another machine. It can be changed by using the
> the
> Surface Area Configuration Tool SQLSAC.exe see previous post
> http://tinyurl.com/23dum6 for links on this.
> John
and configured IIS as requested. I have created a simple table for testing
but cannot establish a DSN connection using either SQL or SQL Native driver
It mentioned something about allowing remote connections, but that feature
is turned on.. so not sure what else i need to configure to allow me to
connect so i can start testing some things out..
any sites or even books i can take a look at to complete this would be
great.
Hi Daniel
"Daniel" wrote:
> I recently installed SQL express on my winXP machine at home... Installed
> and configured IIS as requested. I have created a simple table for testing
> but cannot establish a DSN connection using either SQL or SQL Native driver
> It mentioned something about allowing remote connections, but that feature
> is turned on.. so not sure what else i need to configure to allow me to
> connect so i can start testing some things out..
> any sites or even books i can take a look at to complete this would be
> great.
>
A remote connection should only be needed if you are trying to access your
SQL Express instance from another machine. It can be changed by using the the
Surface Area Configuration Tool SQLSAC.exe see previous post
http://tinyurl.com/23dum6 for links on this.
John
|||I figured as much... when i installed it i took all the defaults and didnt
change anything.. but i will try this later tonight...
thanks for the reply.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:75A3F905-C157-4283-A407-3DA7BA72A7D7@.microsoft.com...
> Hi Daniel
> "Daniel" wrote:
> A remote connection should only be needed if you are trying to access your
> SQL Express instance from another machine. It can be changed by using the
> the
> Surface Area Configuration Tool SQLSAC.exe see previous post
> http://tinyurl.com/23dum6 for links on this.
> John
Subscribe to:
Posts (Atom)