Click here to Skip to main content
14,660,578 members
Home » Discussions » Database
   

Database

 
AnswerRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
arnold_w27-Apr-20 1:49
Memberarnold_w27-Apr-20 1:49 
GeneralRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
Richard MacCutchan27-Apr-20 2:46
mveRichard MacCutchan27-Apr-20 2:46 
GeneralRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
Mycroft Holmes27-Apr-20 12:35
professionalMycroft Holmes27-Apr-20 12:35 
GeneralRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
arnold_w27-Apr-20 19:44
Memberarnold_w27-Apr-20 19:44 
GeneralRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
Mycroft Holmes27-Apr-20 21:43
professionalMycroft Holmes27-Apr-20 21:43 
AnswerRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
Richard MacCutchan25-Apr-20 21:42
mveRichard MacCutchan25-Apr-20 21:42 
AnswerRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
jschell26-Apr-20 10:18
Memberjschell26-Apr-20 10:18 
AnswerRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
arnold_w30-Apr-20 4:16
Memberarnold_w30-Apr-20 4:16 
I found a really great tool where I can browse for an .mdf-file and select it and then see the tables with all the data. It's called "SysInfoTools SQL File Viewer v18.0" and it's only a few megabytes large. After I have installed it, I can see a file called "Script Instruction.txt" in the installation folder with the following contents:

"**********************************************************************
Information about script
**********************************************************************

Mainsqlscript.bat is our main script File, which contains path information of all the tables, views, stored procedure, triggers, functions,etc.

Script file with database name “Databasename”.sql File contains script for creation of Database.

Tables Folder Contain Script of all the tables.
StoreProcedure Folder Contain script file for every Procedure.
Triggers Folder Contain script file for every Trigger.
Views Folder Contain script file for every view.
Functions Folder Contain script file for every function.

altertablecommandPrimarykeys contain script file for every primarykey.
Altertablecommandforeignkeys contain script file for every foreign key.

**********************************************************************
How to run Script
**********************************************************************
1. Open Command prompt. Cmd.exe with run as Administrator.
2. Move to Batch file path using command cd "Path of batch file"
3. Type Command

mainsqlscript.bat <username> <password> <server name=""> <database name="">

NOTE: If the given Database name already exist in sql server instance then old database will be deleted and new database with the given name is created.

Server Name and Database Name are compulsary parameters for running script."

Does anybody understand what they mean by the above, does it mean that I can run it from a standard .bat-file (the ones that were invented by Microsoft in the 80's) and not have to see the GUI show up?
QuestionNo rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23518-Apr-20 21:59
MemberUranium-23518-Apr-20 21:59 
AnswerRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan18-Apr-20 22:50
mveRichard MacCutchan18-Apr-20 22:50 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 3:33
MemberUranium-23519-Apr-20 3:33 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 4:11
mveRichard MacCutchan19-Apr-20 4:11 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 4:39
MemberUranium-23519-Apr-20 4:39 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 4:52
mveRichard MacCutchan19-Apr-20 4:52 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 16:37
MemberUranium-23519-Apr-20 16:37 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 21:46
mveRichard MacCutchan19-Apr-20 21:46 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 23:05
MemberUranium-23519-Apr-20 23:05 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 23:35
mveRichard MacCutchan19-Apr-20 23:35 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23520-Apr-20 9:44
MemberUranium-23520-Apr-20 9:44 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan20-Apr-20 21:36
mveRichard MacCutchan20-Apr-20 21:36 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard Deeming21-Apr-20 0:35
mveRichard Deeming21-Apr-20 0:35 
Questioncomplicated SQL Join request from two server Pin
Member 1473386615-Apr-20 21:11
MemberMember 1473386615-Apr-20 21:11 
AnswerRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 0:08
mveRichard Deeming16-Apr-20 0:08 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 2:36
MemberMember 1473386616-Apr-20 2:36 
GeneralRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 2:48
mveRichard Deeming16-Apr-20 2:48 

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.