June 19, 2014 at 6:25 am
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.
June 19, 2014 at 7:42 am
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 http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 23, 2014 at 11:34 pm
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.
June 24, 2014 at 7:48 am
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 http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 25, 2014 at 7:03 am
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.
June 25, 2014 at 7:20 am
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 http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 25, 2014 at 8:11 am
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?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply