[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

Exporting table data to an external server

I am looking for a simple way to export four tables from our internal Sql Server 2005 database ("Server A") to an external SQL Server 2005 database ("Server B").   Server A is hosted locally and Server B is hosted away from our location. I usually access it via Remote desktop.  This purpose of this export is for archival processes.

1. Is this even possible?
2. Is this easy to do?
3. Is this practical?  (or is there a better suggestion from getting the data from Server A to Server B)

Up to this point I have been doing a backup on Server A, emailing the backup to myself, then doing a restore on Server B. This seems inefficient. Suggestions?
0
vcbertini
Asked:
vcbertini
1 Solution
 
natecudfCommented:
If there is sufficient connectivity, building a SSIS package between the two servers(i.e., VPN, etc, allowing Server A to connect to Server B and vice versa) approach.  Create a Publication on Server A, then build a corresponding subscription on Server B. alternatively, you could also link the two servers(requiires similiar connectivity as before) and have a scheduled script to programmatically pull the data from A to B.  
0
 
vcbertiniAuthor Commented:
It might be easier to push the data since Server A is behind a firewall. What kind of connectivity are you referring to? Is this FTP or ODBC or something like that? I'm kind of new to SSIS packages.
0
 
Imran Javed ZiaCommented:
This thing is technically called as Replication,  please follow the link for other details:
http://msdn.microsoft.com/en-us/library/ms151198(v=SQL.90).aspx
0
 
Alpesh PatelAssistant ConsultantCommented:
Hey, if your external server has live IP then you connect it at your desktop SSMS and use import/export wizard to pull or push the data here and from.
0
 
vcbertiniAuthor Commented:
I'm not exactly sure what our external server has since it is a hosted server. Is there a standard connectivity method that one can use from one server to another? I have a bunch of databases, stored procedures and tables to move over (i guess "replicate"), and I can't even get the servers to talk to one another. How do I get them to connect?
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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