SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Design HELP FOR TO N FRO MOVEMENT OF DATA.


Design HELP FOR TO N FRO MOVEMENT OF DATA.

Author
Message
harsimranjeetsinghwasson
harsimranjeetsinghwasson
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 239
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.
Sean Lange
Sean Lange
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64816 Visits: 17979
harsimranjeetsinghwasson (6/19/2014)
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.





huh?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
harsimranjeetsinghwasson
harsimranjeetsinghwasson
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 239
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.
Sean Lange
Sean Lange
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64816 Visits: 17979
harsimranjeetsinghwasson (6/23/2014)
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.


Your question is not at all clear. Are you asking how to copy data from one database to another?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
harsimranjeetsinghwasson
harsimranjeetsinghwasson
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 239
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.
Sean Lange
Sean Lange
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64816 Visits: 17979
harsimranjeetsinghwasson (6/25/2014)
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.


I am bit confused. The best way to do this is with an SSIS package.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
harsimranjeetsinghwasson
harsimranjeetsinghwasson
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 239
Sean,

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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search