export table in one server to another server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

export table in one server to another server

Author

Topic

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2011-08-08 : 07:39:50

Dear Member

I have export table in one database of one server to another server database table in following condition

1) database name is different.
2) export record depend on date column.

so how i can do this

i have use source server is sql server2005 is sp2 and destination server is sql server 2005 sp3
i have schedule this in JOB

So please send any script or any methods

thanks in advance

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-08 : 08:14:29

you can use export import wizard for creating the transfer package. you can then save it in your server and then add a sql job in sql agent to call and execute this package according to your schedule.
you've two options inside the package which enables you to directly map tables or map based on query which you can utilise for 1 and 2

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2011-08-09 : 00:55:54

thanks to reply
i have using sql2005 the edition of Microsoft SQL Server Standard Edition (64-bit)
i thing export import wizard is not available in this edition
so please tell another way to export import table.

it is good way to use transctional replication ?.
please suggest me.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-09 : 10:16:41

quote:
Originally posted by amirs

thanks to reply
i have using sql2005 the edition of Microsoft SQL Server Standard Edition (64-bit)
i thing export import wizard is not available in this edition
so please tell another way to export import table.

it is good way to use transctional replication ?.
please suggest me.

you've export import wizard. just go to sql management studio connect to your server. expand the required database. choose tasks -> export data and it will launch export import wizard

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources