Hello, Salim!

If you only want to migrate changed (UPDATED/DELETED/INSERTED) data then you
could look to store those records in trigger tables flagging the action
taken. Overnight you would move those rows to your other server and apply
the necessary actions. A good task for this is the Data Driven Query task.

You can use a commandline zip tool i.e. PKZIP. Which will allow you to
dynamically zip a file with the aid of a batch file.

You can roll your own procedure

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: Hi,
: I need to export only the data from server1 to server2 without deleting
and
: creating the existing data on server2.Can I do that?
: Also,can I backup the db on server1 and zip the backup file and send the
: backup file to the pc which runs the server2 and unzip the file and
restore
: it?Can I do that programmatically with .NET or with a free tool?
: Any idea will accepted greatfully.
: Thanks a lot,
: Salim

--- Microsoft Outlook Express 6.00.2800.1158

Hello, Salim!

If some tables have not got a PK then how do you hope to identify a record ?

If you cannot identify a record then you can't compare it to anything.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
: news:exltvMVQDHA.2476 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
??>> Hello, Salim!
??>>
??>> If you only want to migrate changed (UPDATED/DELETED/INSERTED) data
then
: you
??>> could look to store those records in trigger tables flagging the action
??>> taken. Overnight you would move those rows to your other server and
apply
??>> the necessary actions. A good task for this is the Data Driven Query
: task.
??>>
??>> You can use a commandline zip tool i.e. PKZIP. Which will allow you to
??>> dynamically zip a file with the aid of a batch file.
??>>
??>> You can roll your own procedure
??>>
??>> --
??>>
??>> Allan Mitchell (Microsoft SQL Server MVP)
??>> MCSE,MCDBA
??>> www.SQLDTS.com
??>> I support PASS - the definitive, global community
??>> for SQL Server professionals - http://www.sqlpass.org
??>>
??>> : Hi,
??>> : I need to export only the data from server1 to server2 without
deleting
??>> and
??>> : creating the existing data on server2.Can I do that?
??>> : Also,can I backup the db on server1 and zip the backup file and send
the
??>> : backup file to the pc which runs the server2 and unzip the file and
??>> restore
??>> : it?Can I do that programmatically with .NET or with a free tool?
??>> : Any idea will accepted greatfully.
??>> : Thanks a lot,
??>> : Salim
??>>
--- Microsoft Outlook Express 6.00.2800.1158