Copy DTS to another sql-server

Hey,
How can I copy an DTS to another SQL-server?
I made the dts on a testmachine and want to move it now to the SQL-server on
the production machine.
Thanks
Nic
Hi
Open the Package in DTS Designer and then select "Save As". Save it as
structured storage file.
Copy the file to the new server.
From BOL:
To open a DTS package saved to a structured storage file
In the SQL Server Enterprise Manager console tree, right-click Data
Transformation Services, and then click Open Package.
In the Select File dialog box, click the .dts file you want, and then click
Open.
If multiple Data Transformation Services (DTS) packages or package versions
were saved, the Select Package dialog box appears. Click the package or
package version you want to open.
This is all documented in SQL Server Books Online.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
on
> the production machine.
> Thanks
> Nic
|||Hi,
Alternative approaches.
http://databasejournal.com/features/...le.php/1461521
http://www.sqldts.com/default.aspx?242
Thanks
Hari
SQL Server MVP
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
> on
> the production machine.
> Thanks
> Nic

Copy DTS to another sql-server

Hey,
How can I copy an DTS to another SQL-server?
I made the dts on a testmachine and want to move it now to the SQL-server on
the production machine.
Thanks
NicHi
Open the Package in DTS Designer and then select "Save As". Save it as
structured storage file.
Copy the file to the new server.
From BOL:
To open a DTS package saved to a structured storage file
In the SQL Server Enterprise Manager console tree, right-click Data
Transformation Services, and then click Open Package.
In the Select File dialog box, click the .dts file you want, and then click
Open.
If multiple Data Transformation Services (DTS) packages or package versions
were saved, the Select Package dialog box appears. Click the package or
package version you want to open.
This is all documented in SQL Server Books Online.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
on
> the production machine.
> Thanks
> Nic|||Hi,
Alternative approaches.
http://databasejournal.com/features...cle.php/1461521
http://www.sqldts.com/default.aspx?242
Thanks
Hari
SQL Server MVP
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
> on
> the production machine.
> Thanks
> Nic

Copy database from MSDE to SqlServer

Is there any easy way to copy a database from MSDE to SQLServer. MSDE is on
the test server and we would like to copy the whole database, table data,
structure and stored procedures.
"Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>
Use the copy objects wizard in DTS within Enterprise Manager (if they can
see each other over the network
or
Stop the MSDE services. Copy the mdb file to the SQL Server. Use the
SP_attache_single_file_db stored procedure to attch it to the new database.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
|||Hi,
There are 2 options:-
1. Detach and Attach database
2. Backup and Restore the database
1. Detach and Attach
a. Use SP_DETACH_DB to detach the MDF and LDF files
b. Copy the files to Destination server
c. Use SP_ATTACH_DB to attach the databases
(Refer books online for information)
2. Backup and Restore
a. Backup the source databases using BACKUP DATABASE command
b. Copy the .BAK files to destination
c. Restore the database using RESTORE DATABASE command
If you have only 1 or 2 users to syncronize then use the procedure
sp_change_users_login (Refer books online)
If you have more users then; Have a look into the below link for
information.
http://www.databasejournal.com/featu...le.php/2228611
Thanks
Hari
MCDBA
"Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>

Copy database from MSDE to SqlServer

Is there any easy way to copy a database from MSDE to SQLServer. MSDE is on
the test server and we would like to copy the whole database, table data,
structure and stored procedures."Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>
Use the copy objects wizard in DTS within Enterprise Manager (if they can
see each other over the network
or
Stop the MSDE services. Copy the mdb file to the SQL Server. Use the
SP_attache_single_file_db stored procedure to attch it to the new database.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004|||Hi,
There are 2 options:-
1. Detach and Attach database
2. Backup and Restore the database
1. Detach and Attach
a. Use SP_DETACH_DB to detach the MDF and LDF files
b. Copy the files to Destination server
c. Use SP_ATTACH_DB to attach the databases
(Refer books online for information)
2. Backup and Restore
a. Backup the source databases using BACKUP DATABASE command
b. Copy the .BAK files to destination
c. Restore the database using RESTORE DATABASE command
If you have only 1 or 2 users to syncronize then use the procedure
sp_change_users_login (Refer books online)
If you have more users then; Have a look into the below link for
information.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>