SQLServerCentral.com / Security / SQL Server 7,2000 / Design HELP FOR TO N FRO MOVEMENT OF DATA. / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 07:13:33 GMT20RE: Design HELP FOR TO N FRO MOVEMENT OF DATA.http://www.sqlservercentral.com/Forums/Topic1583759-6-1.aspxSean,If i am using ssis package to copy database from one server to another public server..how securely i can achieve this...- Like data will first should be imported into flat file and then it should be imported to public server..- Another thing for security perspective i was thinking was pushing by one sql user having access to that database only.Are there any other ways for securely doing ETL.I was reading about TDE(Transparent Data Encryption). Is that helpful?Wed, 25 Jun 2014 08:11:49 GMTharsimranjeetsinghwassonRE: Design HELP FOR TO N FRO MOVEMENT OF DATA.http://www.sqlservercentral.com/Forums/Topic1583759-6-1.aspx[quote][b]harsimranjeetsinghwasson (6/25/2014)[/b][hr]Yes Sean,I need to execute nightly SSIS Package to copy the data from database on one server which will be local to me.to the database server which will be public and hosted somewhere else.What are the best way to copy data over the network to and fro.[/quote]I am bit confused. The best way to do this is with an SSIS package.Wed, 25 Jun 2014 07:20:33 GMTSean LangeRE: Design HELP FOR TO N FRO MOVEMENT OF DATA.http://www.sqlservercentral.com/Forums/Topic1583759-6-1.aspxYes Sean,I need to execute nightly SSIS Package to copy the data from database on one server which will be local to me.to the database server which will be public and hosted somewhere else.What are the best way to copy data over the network to and fro.Wed, 25 Jun 2014 07:03:33 GMTharsimranjeetsinghwassonRE: Design HELP FOR TO N FRO MOVEMENT OF DATA.http://www.sqlservercentral.com/Forums/Topic1583759-6-1.aspx[quote][b]harsimranjeetsinghwasson (6/23/2014)[/b][hr]Pushing Data from Database on local Server to database on public Server.Need precautions to send secure data or how to process this to and fro movement of data.[/quote]Your question is not at all clear. Are you asking how to copy data from one database to another?Tue, 24 Jun 2014 07:48:26 GMTSean LangeRE: Design HELP FOR TO N FRO MOVEMENT OF DATA.http://www.sqlservercentral.com/Forums/Topic1583759-6-1.aspxPushing Data from Database on local Server to database on public Server.Need precautions to send secure data or how to process this to and fro movement of data.Mon, 23 Jun 2014 23:34:58 GMTharsimranjeetsinghwassonRE: Design HELP FOR TO N FRO MOVEMENT OF DATA.http://www.sqlservercentral.com/Forums/Topic1583759-6-1.aspx[quote][b]harsimranjeetsinghwasson (6/19/2014)[/b][hr]What protocols or list of steps can be followed while pushing and pulling data from intranet to internet,where data in intranet is peculiar and important than data on internet.For example, we have a server on intranet with live data of clinic transaction and respective patients..but on live we need to show only available appointment that will be stored on online database or on public server.[/quote]huh?Thu, 19 Jun 2014 07:42:04 GMTSean LangeDesign HELP FOR TO N FRO MOVEMENT OF DATA.http://www.sqlservercentral.com/Forums/Topic1583759-6-1.aspxWhat protocols or list of steps can be followed while pushing and pulling data from intranet to internet,where data in intranet is peculiar and important than data on internet.For example, we have a server on intranet with live data of clinic transaction and respective patients..but on live we need to show only available appointment that will be stored on online database or on public server.Thu, 19 Jun 2014 06:25:37 GMTharsimranjeetsinghwasson