Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Design HELP FOR TO N FRO MOVEMENT OF DATA. Expand / Collapse
Author
Message
Posted Thursday, June 19, 2014 6:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 47, Visits: 169
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.



Post #1583759
Posted Thursday, June 19, 2014 7:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 13,067, Visits: 11,903
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 Moden's 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)
Post #1583822
Posted Monday, June 23, 2014 11:34 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 47, Visits: 169
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.
Post #1585382
Posted Tuesday, June 24, 2014 7:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 13,067, Visits: 11,903
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 Moden's 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)
Post #1585512
Posted Wednesday, June 25, 2014 7:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 47, Visits: 169
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.
Post #1585878
Posted Wednesday, June 25, 2014 7:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 13,067, Visits: 11,903
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 Moden's 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)
Post #1585886
Posted Wednesday, June 25, 2014 8:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 47, Visits: 169
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?


Post #1585912
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse