Click here to Skip to main content
14,769,451 members
Home » Discussions » Database
   

Database

 
QuestionVisual Studio Database Projects and General Use Pin
cjb11018-Oct-16 3:38
Membercjb11018-Oct-16 3:38 
AnswerRe: Visual Studio Database Projects and General Use Pin
Matt U.18-Oct-16 11:12
MemberMatt U.18-Oct-16 11:12 
GeneralRe: Visual Studio Database Projects and General Use Pin
cjb11019-Oct-16 21:56
Membercjb11019-Oct-16 21:56 
GeneralRe: Visual Studio Database Projects and General Use Pin
Matt U.20-Oct-16 6:01
MemberMatt U.20-Oct-16 6:01 
SuggestionIncrease the Execution time or Connection Time out property of SSIS package from C# code Pin
indian14312-Oct-16 14:40
Memberindian14312-Oct-16 14:40 
QuestionTo run a SSIS package outside of SQL server data tools you must install populate filecollection of integration services or higher Pin
indian14310-Oct-16 7:39
Memberindian14310-Oct-16 7:39 
AnswerRe: To run a SSIS package outside of SQL server data tools you must install populate filecollection of integration services or higher - resolved Pin
indian14312-Oct-16 13:58
Memberindian14312-Oct-16 13:58 
QuestionExport Access db to Sql Server db everyday Pin
meeram396-Oct-16 16:09
professionalmeeram396-Oct-16 16:09 
I have an MS Access db that needs to export to Sql Server on daily basis. The access database contains numerous tables and views associated with it. Everyday basis, this gets updated and it's ok to replace the database on daily basis. Sometimes the structure remains the same, but the data in many of the tables will be more on each day. Modifications to existing structure is also possible sometimes.

So, rather than appending data to the existing tables, I would like to replace the whole database on daily basis in Sql Server and perform operations on it.And it should be scheduled at a particular time. So I am looking out which will be the best option to do the same. Will the SSIS packages helpful? Please suggest possible ways.
AnswerRe: Export Access db to Sql Server db everyday Pin
Eddy Vluggen10-Oct-16 7:58
professionalEddy Vluggen10-Oct-16 7:58 
QuestionIdentity_Column Pin
Member 111616253-Oct-16 20:43
MemberMember 111616253-Oct-16 20:43 
AnswerRe: Identity_Column Pin
Chris Quinn4-Oct-16 0:11
MemberChris Quinn4-Oct-16 0:11 
AnswerRe: Identity_Column Pin
Swinkaran4-Oct-16 2:17
professionalSwinkaran4-Oct-16 2:17 
QuestionSQL Server Reporting Services Query to Get Stored Procedure Name for Shared Dataset Pin
David_4129-Sep-16 12:48
MemberDavid_4129-Sep-16 12:48 
AnswerRe: SQL Server Reporting Services Query to Get Stored Procedure Name for Shared Dataset Pin
Mycroft Holmes29-Sep-16 13:43
professionalMycroft Holmes29-Sep-16 13:43 
GeneralRe: SQL Server Reporting Services Query to Get Stored Procedure Name for Shared Dataset Pin
David_4129-Sep-16 13:51
MemberDavid_4129-Sep-16 13:51 
QuestionExecuting SSIS Package from C# Console App Pin
indian14328-Sep-16 5:51
Memberindian14328-Sep-16 5:51 
AnswerRe: Executing SSIS Package from C# Console App - resolved Pin
indian14328-Sep-16 13:09
Memberindian14328-Sep-16 13:09 
Question.mdb file problem Pin
Member 1275753624-Sep-16 7:19
MemberMember 1275753624-Sep-16 7:19 
AnswerRe: .mdb file problem Pin
Mycroft Holmes24-Sep-16 15:49
professionalMycroft Holmes24-Sep-16 15:49 
GeneralRe: .mdb file problem Pin
Richard Deeming26-Sep-16 3:12
mveRichard Deeming26-Sep-16 3:12 
GeneralRe: .mdb file problem Pin
Mycroft Holmes26-Sep-16 13:33
professionalMycroft Holmes26-Sep-16 13:33 
AnswerRe: .mdb file problem Pin
Victor Nijegorodov25-Sep-16 4:31
MemberVictor Nijegorodov25-Sep-16 4:31 
QuestionHow to update Oracle DB from SQL server through link server? Pin
hmanhha22-Sep-16 21:20
Memberhmanhha22-Sep-16 21:20 
AnswerRe: How to update Oracle DB from SQL server through link server? Pin
Richard MacCutchan22-Sep-16 21:53
mveRichard MacCutchan22-Sep-16 21:53 
GeneralRe: How to update Oracle DB from SQL server through link server? Pin
hmanhha22-Sep-16 22:28
Memberhmanhha22-Sep-16 22:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.