Moving data from server to server 
Author Message
 Moving data from server to server
What is the easiest way to move a SQL Server 7 database to another same type
of server? The source is located in company LAN, which is connected to the
Internet through ADSL. The destination server is administered remotely and
is connected to the Internet with T1.

Thanks.



Tue, 09 Dec 2003 04:38:34 GMT
 Moving data from server to server

My choice would be just to copy the mdf and ldf files in your current \data
directory to the one on the other LAN machine.  Once there, you can open
Enterprise Manager, right click on Databases -> All Tasks -> (in the new
computer) and "Attach Database..."   Browse.., select the database files,
and you're done.

--

Quote:
> What is the easiest way to move a SQL Server 7 database to another same
type
> of server? The source is located in company LAN, which is connected to the
> Internet through ADSL. The destination server is administered remotely and
> is connected to the Internet with T1.

> Thanks.



Tue, 09 Dec 2003 05:12:11 GMT
 Moving data from server to server
Does this solution appy to sql7?  I am trying to follow these
instructions, but I can't find the  "Attach Database..."  option..

On Thu, 21 Jun 2001 17:12:11 -0400, "Nathaniel E. Bibler"

Quote:

>My choice would be just to copy the mdf and ldf files in your current \data
>directory to the one on the other LAN machine.  Once there, you can open
>Enterprise Manager, right click on Databases -> All Tasks -> (in the new
>computer) and "Attach Database..."   Browse.., select the database files,
>and you're done.



Tue, 09 Dec 2003 06:49:24 GMT
 Moving data from server to server
Check out using DTS to copy the data and the database objects.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> What is the easiest way to move a SQL Server 7 database to another same
type
> of server? The source is located in company LAN, which is connected to the
> Internet through ADSL. The destination server is administered remotely and
> is connected to the Internet with T1.

> Thanks.



Tue, 09 Dec 2003 08:16:09 GMT
 Moving data from server to server
In SQL Server 7.0, Enterprise Manager does not have an "Attach Database ..."
option. You will have to use T-SQL code ... check out the documentation on
the sp_detach_db and sp_attach_db system stored procedures in the SQL Server
7.0 Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> Does this solution appy to sql7?  I am trying to follow these
> instructions, but I can't find the  "Attach Database..."  option..

> On Thu, 21 Jun 2001 17:12:11 -0400, "Nathaniel E. Bibler"

> >My choice would be just to copy the mdf and ldf files in your current
\data
> >directory to the one on the other LAN machine.  Once there, you can open
> >Enterprise Manager, right click on Databases -> All Tasks -> (in the new
> >computer) and "Attach Database..."   Browse.., select the database files,
> >and you're done.



Tue, 09 Dec 2003 08:31:56 GMT
 Moving data from server to server
Is this a one time move? Or is this an operation that runs continuously?

If it's one time then just use DTS, specify your source and destination, then
run immediately.

If it's a continuous job, then create a DTS script and with the right
parameters, you can let it run.

Contact me if you need help creating the DTS.

Thomas J. Raef



Wed, 10 Dec 2003 20:07:03 GMT
 Moving data from server to server
I've done a lot of DTS over the LAN but not the Internet - is this
feasable?

I create a package on a Centralised server with a static IP address
with many DDQ/Transfer Tasks. Client servers dialup and start the
package. IIS has identified the client server name and passes it to
the Centralised server which loads the server name into the DataSource
property of the client server connection using the Dynamic Properties
task and then the data transfers from the client to the server are
kicked off. Data consistency is maintained because each client only
transfer its own data.

Is there some awful thing I have overlooked.

Regards

Robert Couldry

Quote:

> Is this a one time move? Or is this an operation that runs continuously?

> If it's one time then just use DTS, specify your source and destination, then
> run immediately.

> If it's a continuous job, then create a DTS script and with the right
> parameters, you can let it run.

> Contact me if you need help creating the DTS.

> Thomas J. Raef




Fri, 26 Dec 2003 19:48:13 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Moving data from server to server

2. Moving SQL Server Data to a New Server on same network

3. Move image data from server to server

4. Moving Data Server to Server - Best Practices methodology

5. Moving alerts from one server to another server in sql server 6.5

6. how to move data from Excel to SQL Server

7. Moving Data from one SQL server to another???

8. SQL Server data moved to Oracle

9. Moving data across servers in SQL 6.5

10. Dynamically moving data from Sql Server database to Oracle/DB2

11. Move data from dev to production server?

12. Moving databases and data devices to new server in SQL 6.5


 
Powered by phpBB® Forum Software