|
Home > Archive > MS SQL Server > January 2006 > help with dts package
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
help with dts package
|
|
|
| Hi I am using the import wizard to import data from a mysql database to
mssql. I have set up the driver to access the mysql data. Anyhow I want to
save this as a dts package and have it run nightly but I want it to overwrite
the existing data in the destination database. Just wondering if this will
work correctly or will it rename the tables it imports so I end up with two
sets of tables. Thanks.
--
Paul G
Software engineer.
| |
| John Bell 2006-01-03, 8:23 pm |
| Hi Paul
If you choose the "Copy Objects and Data" option then you will see a screen
with check boxes for Create Destination Objects, Drop Destination Objects
First, Copy Data, Replace (existing data) and Append. If you de-select the
copy all objects the select object button will become available to choose
specific tables. If you only choose to copy tables, then you will need to
click on the transform button to get similar options. If the tables are
created before you try to set up the import then the transform options will
allow to do more.
John
"Paul" <Paul@discussions.microsoft.com> wrote in message
news:D38F4651-9A60-4B05-9436- 2333F54A7467@microso
ft.com...
> Hi I am using the import wizard to import data from a mysql database to
> mssql. I have set up the driver to access the mysql data. Anyhow I want
> to
> save this as a dts package and have it run nightly but I want it to
> overwrite
> the existing data in the destination database. Just wondering if this
> will
> work correctly or will it rename the tables it imports so I end up with
> two
> sets of tables. Thanks.
> --
> Paul G
> Software engineer.
| |
|
| ok thanks for the information. Had another problem, I am trying to copy a
dbase from one server to another so first created a backup file from source
server, copied to destination server. Then created an empty dbase with same
name on destination server, then selected backup, then replaced the backup
file dest server with the one from the source server and tried to restore
from that file. I get the following error, can not find file id 3 on device
c:\program files\....Backup\dbase.bak
--
Paul G
Software engineer.
"John Bell" wrote:
> Hi Paul
>
> If you choose the "Copy Objects and Data" option then you will see a screen
> with check boxes for Create Destination Objects, Drop Destination Objects
> First, Copy Data, Replace (existing data) and Append. If you de-select the
> copy all objects the select object button will become available to choose
> specific tables. If you only choose to copy tables, then you will need to
> click on the transform button to get similar options. If the tables are
> created before you try to set up the import then the transform options will
> allow to do more.
>
> John
>
>
>
> "Paul" <Paul@discussions.microsoft.com> wrote in message
> news:D38F4651-9A60-4B05-9436- 2333F54A7467@microso
ft.com...
>
>
>
| |
| John Bell 2006-01-03, 8:23 pm |
| Hi
Does your backup file has mutiple backups in it, in which case you may want
to specify WITH FILE = file_number on the RESTORE command. Also if your
original server has a different configuration to the new server then you may
need to change the locations of the mdf and ldf files using the MOVE
'logical_file_name' TO 'operating_system_fi
le_name' option. See
http://msdn.microsoft.com/library/d..._ra-rz_25rm.asp
for a description of the RESTORE command.
The following article discusses how you move databases
http://support.microsoft.com/defaul...121120121120120
including the alternative method of using sp_detach_db/sp_attach_db.
John
"Paul" <Paul@discussions.microsoft.com> wrote in message
news:E773BEF2-3E29-4C6D-B4CC- F9781BCB15C1@microso
ft.com...[color=darkred]
> ok thanks for the information. Had another problem, I am trying to copy a
> dbase from one server to another so first created a backup file from
> source
> server, copied to destination server. Then created an empty dbase with
> same
> name on destination server, then selected backup, then replaced the backup
> file dest server with the one from the source server and tried to restore
> from that file. I get the following error, can not find file id 3 on
> device
> c:\program files\....Backup\dbase.bak
> --
> Paul G
> Software engineer.
>
>
> "John Bell" wrote:
>
| |
|
| ok thanks, used the RESTORE command from analyzer and it seemed to work.
--
Paul G
Software engineer.
"John Bell" wrote:
> Hi
>
> Does your backup file has mutiple backups in it, in which case you may want
> to specify WITH FILE = file_number on the RESTORE command. Also if your
> original server has a different configuration to the new server then you may
> need to change the locations of the mdf and ldf files using the MOVE
> 'logical_file_name' TO 'operating_system_fi
le_name' option. See
> http://msdn.microsoft.com/library/d..._ra-rz_25rm.asp
> for a description of the RESTORE command.
>
> The following article discusses how you move databases
> http://support.microsoft.com/defaul...121120121120120
> including the alternative method of using sp_detach_db/sp_attach_db.
>
> John
>
>
> "Paul" <Paul@discussions.microsoft.com> wrote in message
> news:E773BEF2-3E29-4C6D-B4CC- F9781BCB15C1@microso
ft.com...
>
>
>
|
|
|
|
|