moving...

Hi ,

We have a database around 5GB in size, located in remote location . i want to get that database into my local machine. We cannot take back up in tape or any other media from our remote location ,so we have to depend on FTP .

Is there any better solution other than FTP, or DTS import/Export , to transfer whole database to my local machine ?

Please give me some suggestions !

Thanks,

HadleyIts better to take file backup and use FTP to transfer the file. Before than make sure to run DBCC checks against the database to keep it clean.

Even you can use Generate SQL Scripts and run those scripts on the local machine, then use DTS to transfer the data.

HTH

Moving Table to another SQL server using Linked Server

Hi,

I can't seem to find any information on how exactly to do this. Basically I want to move a particular table on my DB to a remote SQL server, and have write operations (destined for that table) to be written directly to the table on the remote server.

How is this done?

Thanks in advance.

If you have set up one server as a linked server, you should be able to set up one of your tables just as a view, so that operations that happen to it actually happen on the underlying one (on the remote server).

That's the theory at least, and it ought to work, but you should be wary of network latency and things like that. You may find it just doesn't perform well enough, and that you need some sort of a process which polls the table on your database for changes that need to be written back. But then the tables won't be perfectly in sync (for obvious reasons).

Robsql

moving SQL Server to remote web server

I'm very new to using SQL Server and have a very basic question that I was hoping someone could help answer or point me in the right direction.

Ive been searching for the information and have been unable to find what Im looking for. I might be using the wrong keywords.

This is what Im trying to find. I have found some information on building a database in Access and porting it over to SQL Server. The information that I've found discusses on a simple level how to use Enterprise Manager to port over using the following steps:
Enterprise Manager:
1) Database level >> Action Menu >> New Database setup a name
2) Highlight new database name
3) Tools Menu >> Data Transformation Services >> Import Data

Data Source = Microsoft Access

Okay, so that is pretty straightforward. If I created the web page using the Access DB and I am using an OLE-DB connection string then once I port over to SQL Server all I should need to change is the connection string to a SQL Server connection string. Is that correct? Anyone know where I can find some information about this process and specifically how to upload the new SQL Server DB to the remote web server? To upload an Access DB, I just FTP the DB to the site directory. Pretty easy. If I understand right, you dont do that with a SQL Server DB, but rather replicate the DB to the remote server. I would like to understand how to move the SQL Server DB to a remote web server. Im trying to learn the steps and how it is done? Thanks in advance for any help.
-D-Follow these links :
http://support.microsoft.com/default.aspx?scid=kb;en-us;247931

http://www.faqts.com/knowledge_base/view.phtml/aid/3332

If this is not what you're looking then kindly come up with more explanation.sql

Moving large amounts of data to remote data center

To set up Disaster Recovery, what do you use to move large amounts of data
i.e. first time data load to the remote data center. This could be more than
500GBs of data.
ThanksHi Hassan
I thought you were using a SAN?
You can now get 500GB+ USB drives!
John
"Hassan" wrote:
> To set up Disaster Recovery, what do you use to move large amounts of data
> i.e. first time data load to the remote data center. This could be more than
> 500GBs of data.
> Thanks
>
>