Click here to Skip to main content
15,850,214 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen17-Nov-15 1:46
professionalEddy Vluggen17-Nov-15 1:46 
QuestionAmazon RDS IP Address Pin
R. Giskard Reventlov21-Oct-15 6:21
R. Giskard Reventlov21-Oct-15 6:21 
SuggestionRe: Amazon RDS IP Address Pin
Kornfeld Eliyahu Peter21-Oct-15 9:50
professionalKornfeld Eliyahu Peter21-Oct-15 9:50 
GeneralRe: Amazon RDS IP Address Pin
R. Giskard Reventlov21-Oct-15 10:09
R. Giskard Reventlov21-Oct-15 10:09 
QuestionValidating data between RDBMS (Mysql/ Oracle / DB2) and Hadoop ( HDFS/ Hive) Pin
Member 1204409721-Oct-15 5:14
Member 1204409721-Oct-15 5:14 
AnswerRe: Validating data between RDBMS (Mysql/ Oracle / DB2) and Hadoop ( HDFS/ Hive) Pin
Richard Deeming21-Oct-15 9:12
mveRichard Deeming21-Oct-15 9:12 
QuestionSchema update using SQL Server Data Tools Pin
indian14319-Oct-15 13:15
indian14319-Oct-15 13:15 
Hi All,

I have two different databases on two different servers I compared the source database with destination database, there are few things like a Foreign key doesn't exist in the target database, a couple of columns are missing. Now after finding it, I want to update the schema from Source database to Destination database without losing the data on the target database.

When I ran it, it is giving me error and saying Target database may loose data, can anybody please help me or point me, how can I achieve this?

Any suggestion, link or code snippet can be very helpful. Thanks in advance.
Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

AnswerRe: Schema update using SQL Server Data Tools Pin
Mycroft Holmes19-Oct-15 15:35
professionalMycroft Holmes19-Oct-15 15:35 
GeneralRe: Schema update using SQL Server Data Tools Pin
indian14319-Oct-15 16:54
indian14319-Oct-15 16:54 
QuestionReferencing DacPac file from different Server and Database Pin
indian14319-Oct-15 11:34
indian14319-Oct-15 11:34 
AnswerRe: Referencing DacPac file from different Server and Database Pin
Mycroft Holmes19-Oct-15 15:30
professionalMycroft Holmes19-Oct-15 15:30 
QuestionLimiting the scope of a Table variable Pin
indian14317-Oct-15 7:35
indian14317-Oct-15 7:35 
AnswerRe: Limiting the scope of a Table variable Pin
Mycroft Holmes17-Oct-15 14:40
professionalMycroft Holmes17-Oct-15 14:40 
GeneralRe: Limiting the scope of a Table variable Pin
indian14319-Oct-15 11:28
indian14319-Oct-15 11:28 
QuestionMove GROUP_CONCAT's comma values to columns Pin
Jassim Rahma15-Oct-15 7:45
Jassim Rahma15-Oct-15 7:45 
AnswerRe: Move GROUP_CONCAT's comma values to columns Pin
Jassim Rahma15-Oct-15 9:02
Jassim Rahma15-Oct-15 9:02 
GeneralRe: Move GROUP_CONCAT's comma values to columns Pin
Jassim Rahma24-Oct-15 2:28
Jassim Rahma24-Oct-15 2:28 
QuestionFilling many to many rel table using Select statement Pin
indian14314-Oct-15 8:18
indian14314-Oct-15 8:18 
AnswerRe: Filling many to many rel table using Select statement Pin
Mycroft Holmes14-Oct-15 13:50
professionalMycroft Holmes14-Oct-15 13:50 
GeneralRe: Filling many to many rel table using Select statement Pin
KDGOLE14-Oct-15 22:27
KDGOLE14-Oct-15 22:27 
GeneralRe: Filling many to many rel table using Select statement Pin
indian14317-Oct-15 7:17
indian14317-Oct-15 7:17 
GeneralRe: Filling many to many rel table using Select statement Pin
indian14319-Oct-15 11:30
indian14319-Oct-15 11:30 
QuestionGet check time from separate fields in Microsoft SQL Server Pin
Jassim Rahma14-Oct-15 1:11
Jassim Rahma14-Oct-15 1:11 
AnswerRe: Get check time from separate fields in Microsoft SQL Server Pin
Mycroft Holmes14-Oct-15 2:11
professionalMycroft Holmes14-Oct-15 2:11 
GeneralRe: Get check time from separate fields in Microsoft SQL Server Pin
Chris Quinn14-Oct-15 3:30
Chris Quinn14-Oct-15 3:30 

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.