Copying Data from one server to the other

Hello
Could someone tell the easiest way of copying data from one server to
the other.
I have a Sql Server 7.0 database in a test server and a production
server. The database structure and schema is identical in both the
servers. I want the data copied from Production server to Test server.
Is there a way where I can automate this by either writing a script or
any other method. Would appreciate any help on this.
Thanks
Sue..Did you try DTS?
Right-click a table, and choose All Tasks > Export Data.
"Sue" <sansid_iyer@.hotmail.com> wrote in message
news:ab28dd65.0310070739.19d6a251@.posting.google.com...
> Hello
> Could someone tell the easiest way of copying data from one server to
> the other.
> I have a Sql Server 7.0 database in a test server and a production
> server. The database structure and schema is identical in both the
> servers. I want the data copied from Production server to Test server.
> Is there a way where I can automate this by either writing a script or
> any other method. Would appreciate any help on this.
> Thanks
> Sue..|||You can do this either by creating a DTS task that you schedule with SQL
Agent (i.e. with DTS Import/Export Wizard), or create a VBScript using
SQL-DMO Transfer object to copy your data which you can then schedule with
Agent ActiveX job step.
These are just 2 ways - I'm sure others will chime in with alternative
methods.
--
Michiel Wories, SQL Server PM
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"Sue" <sansid_iyer@.hotmail.com> wrote in message
news:ab28dd65.0310070739.19d6a251@.posting.google.com...
> Hello
> Could someone tell the easiest way of copying data from one server to
> the other.
> I have a Sql Server 7.0 database in a test server and a production
> server. The database structure and schema is identical in both the
> servers. I want the data copied from Production server to Test server.
> Is there a way where I can automate this by either writing a script or
> any other method. Would appreciate any help on this.
> Thanks
> Sue..