MS SQL Server, Moving data from server to server

Moving data from server to server

Author	Message
Tuoma #1 / 7	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

Nathaniel E. Bible #2 / 7	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

ja #3 / 7	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

BP Margoli #4 / 7	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

BP Margoli #5 / 7	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

TRaef #6 / 7	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

Robert Could #7 / 7	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

Page 1 of 1

[ 7 post ]