|
If you write an application that retrieves the data from 1 database and reformats it and writes it into the new database, I suppose that could be called migrating it via a web application.
The sensible way to do this is:
1. Backup both databases
2. Restore onto another server/instance/database name
3. Start writing scripts that reformats the data into the normalised database
4. Test each script and make sure your results are what you expect and the data is properly normalised
5. repeat step 2
6. Run all scripts together
7. Test against your application.
8. Refresh the backup of the production databases
9. Repeat steps 5 & 6
10. Restore the new normalised backup to production.
11. Turn off the old database (you might want to do this at step 8
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks RAH for your quick reply.
what type of scripts,Can you please give sample scripts.
The customer data may be in any format i.e. excel, .csv, flat files, access but the destination is SQL Server.
Thanks,
|
|
|
|
|
Ah I read denormalised database not data and migrating data also implies that there is a system in place to migrate from. I see I was wrong.
What you are talking about is moving garbage into a structured environment, every source will be different and you will need to manually process each new customers data.
This is a straight database operation create a staging database with your current production information in it, create staging tables based on your garbage data source and script the transforms from garbage to your shiny new structure. Each script must be repeatable so when the final move is made you can just reload the staging data ans run the scripts.
Make sure you charge HIGH for this job, it is not trivial.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello there,
I would like to know if I can use HTML & JavaScript to connect and manipulate MS SQL
.
If you know of any web pages that describes/teaches how to do that well be great.
In other words, I would like to use Visual Studio to create an ASP.Net C# website but not use C# but rather pure html and JavaScript to connect and modify a MS SQL database, or MS SQL Express or MS SQL Compact.
I would greatly appreciate help on this subject.
Michael N
wishes you a great day
|
|
|
|
|
|
just use javascript or html can't connect mssql database,At least for now
|
|
|
|
|
No, you cannot. Let me explain. A web application is unlike any client applications. There is this separation of concerns that is called n-tier architecture which consists of client tier (HTML, JavaScript) , server tier (PHP, ASP), and data tier (MSSQL, MySQL).
In a typical scenario, when you want to request information from a database, the request is usually submitted through a HTML form and forwarded to a server-side script, say login.php which in turn validates the content of your submission and if valid, this script will connect to the database and retrieve the information using SQL, and lastly, it will formulate the response in HTML format and send back to the browser for display.
Fundamentally, web applications created in ASP.NET is no different from what I describe above. However, ASP.NET uses server controls that abstracts the creation of HTML contents and the interaction between browsers and servers. In this way, you can use server controls to create web application the way that you used to work with controls in a client application without thinking about the separation of concerns.
|
|
|
|
|
Hi guys,
PLZ help me!
Scenario - My client has 2 server machine. one is database server with oracle 10g database 64-bit. Another server(new one) is windows 2008 server which has an .net 2.0+3.5 website hosted. This website make use of System.data.oracleClient dll . Problem is that this app is not able to connect to oracle 10g database server though it is able to connect to some other 11g R2 database server. On this app server we have also tried to install oracle 10g 32-bit client but still can't access. Tnsping and sqlplus is working fine. Pls. suggest.
Solution that we tried :-
- Gave permission and added various users to oracle directory and sub-directory like IIS_Iuser,network service, anonymous etc.
Possible culprit:-
- Earlier on this app server oracle 11g 32-bit client was installed. So my client has although worked on to remove it by manually deleting folder , deleting registeries , extra home directories. but it looks like a possible reason to me..
Note - we use some internal ddl for dataaccess , so im not able to see actual error just some OLEDB exception.
Pls help
|
|
|
|
|
I have 4 projects: GUI (Web), BLL (C#), DAL (C#) and POCO (C#) and I want to implement a custom membership provider. Here is what I did so far:
1) Created MyMembershipProvider class in DAL that implements MembershipProvider
2) Created the database and the edmx in DAL
Next I think I should implement the User repository, Is it in DAL or BLL ?? And I have a problem passing the connection string from App.config in DAL project to the one on BLL project or Web.config in GUI project. I'm confused, please help
|
|
|
|
|
I am loading dynamic questions in the panel part of aspx page, in the Page_Init method, to avoid situation of losing the values on postback issues. There is a linq statement that loads this dynamic panel.
The same aspx page is used in 3 step registration process, by hiding and showing panels.
This dynamic questionnaire is step 3 of process. I now need to limit the questions that appear on this dynamic queationnaire, by what was entered in step 1 of questionnaire, like a radiobutton choice. How can I pass this to the Page_Init page? Or can i reload this dynamic question which is loaded in page_init, and limit the questions?
Thanks!!
|
|
|
|
|
Whenever you are posting back you can access Request.Form["ElementName"] to get what was the value before the form got posted. I did not understand the purpose of "linq statement that loads this dynamic panel". Can you tell me what is the architecture you are using. Is it Asp .Net Forms or MVC?
|
|
|
|
|
Hello,
I am novice programmer and require little assistance on the error, I am currently experiencing in the default.cs class below.
The name 'name' does not exist in the current context
default.cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Data.SqlClient;
using System.Text;
using System.Collections.Generic;
using System.Web.Services;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static List<Data> GetData()
{
List<Data> dataList = new List<Data>();
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 0, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 78, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 82, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 425, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 79, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 80, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 57, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("ACCDO 11A B", 2, "Sept"));
dataList.Add(new Data("ACCDO 11A B", 2, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 96.89, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 96, "Oct"));
dataList.Add(new Data("AELIS 2013-IRAR C", 97, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Oct"));
dataList.Add(new Data("AELIS 2013-IRAR C", 85, "Sept"));
return dataList.FindAll(r => r.ColumnName.Contains(name));
}
protected void Button1_Click(object sender, EventArgs e)
{
}
}
data.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
public class Data : Default
{
public string ColumnName = "";
public double Value = 0;
public string Date = "";
public Data(string name, double price, string date)
{
ColumnName = name;
Value = price;
Date = date;
}
}
Any help will be very much appreciated.
Thank you.
|
|
|
|
|
Your GetData method does not contain a variable or parameter called name, and your _Default class does not contain an accessible field or property called name. Therefore, the compiler doesn't know what you mean by "name", and cannot compile your code.
Assuming you want to pass the name you're looking for to the method, you need to introduce a parameter:
public static List<Data> GetData(string name)
{
...
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thank you so much for your response. I really appreciate your help.
I manage to solve the compile error but my application now output blank webpage on the client-side. I can not seem to figure out why, but would I have to invoke callback method on the asp.button?
I am trying to build an application which can filter test data and display visual charts using google charts API.
default.aspx
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript" src="//www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1', { packages: ['corechart'] });
</script>
<script type="text/javascript">
$('#Button1').click(function () {
$.ajax({
type: 'POST',
dataType: 'json',
contentType: 'application/json',
url: 'Default.aspx/GetData',
data: "{name:'" + $("#SearchText").val() + "'}",
success:
function (response) {
drawVisualization(response.d);
}
});
})
function drawVisualization(dataValues) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Column Date');
data.addColumn('number', 'Column Value');
for (var i = 0; i < dataValues.length; i++) {
data.addRow([dataValues[i].Date, dataValues[i].Value]);
}
new google.visualization.LineChart(document.getElementById('visualization')).
draw(data, { title: "" });
}
</script>
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Visual Search Testing with 'iFrame
</h2>
<asp:Label ID="Label1" runat="server" Text="Name/Ids"></asp:Label>
<asp:TextBox ID="SearchText" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Search" onclick="Button1_Click" />
<div id="visualization" style="width: 600px; height: 400px;"></div>
</asp:Content>
default.cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Data.SqlClient;
using System.Text;
using System.Collections.Generic;
using System.Web.Services;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static List<Data> GetData(string name)
{
List<Data> dataList = new List<Data>();
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 0, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 78, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 82, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 425, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 79, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 80, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 57, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("ACCDO 11A B", 2, "Sept"));
dataList.Add(new Data("ACCDO 11A B", 2, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 96.89, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 96, "Oct"));
dataList.Add(new Data("AELIS 2013-IRAR C", 97, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Oct"));
dataList.Add(new Data("AELIS 2013-IRAR C", 85, "Sept"));
return dataList.FindAll(r => r.ColumnName.Contains(name));
}
protected void Button1_Click(object sender, EventArgs e)
{
}
}
Any help would be very much appreciated.
Thanks
|
|
|
|
|
miss786 wrote: $('#Button1').click(function () {
Since you're using a master page, the client ID of Button1 won't be "Button1"; it will be something similar to "ctl00$MainContent$Button1".
If you're using ASP.NET 4.0, you can set the button's ClientIDMode[^] to Static, which will make sure that the client ID matches the server ID. If you're using an earlier version of ASP.NET, you'll need to find the correct ID, or use a different selector to find the button.
<asp:Button ID="Button1" runat="server" Text="Search" ClientIDMode="Static" />
You'll need to do the same for the SearchText textbox, since you reference it by ID:
<asp:TextBox ID="SearchText" runat="server" ClientIDMode="Static" />
miss786 wrote: $('#Button1').click(function () {
$.ajax({
...
});
})
You need to end the event handler function with return false;, otherwise the button will cause a post-back and the AJAX call won't run. You should also terminate the statement with a semi-colon.
$("#Button1").click(function(){
$.ajax({
...
});
return false;
});
miss786 wrote: data: "{name:'" + $("#SearchText").val() + "'}",
I'd strongly recommend using the built-in JSON.stringify[^] method to convert the parameters to a string. If you need to support IE7, you can use Douglas Crockford's JSON-js[^] script.
data: JSON.stringify({ name: $("#SearchText").val() }),
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I really appreciate your help and time. I am sorry to inform, I am still unable to get the code to display any output on the client-side. I updated the code to your suggestion but I am still unable to find any errors in the debugging window of chrome developer tool (javascript).
default.aspx
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript" src="//www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1', { packages: ['corechart'] });
</script>
<script type="text/javascript">
$('#Button1').click(function () {
$.ajax({
type: 'POST',
dataType: 'json',
contentType: 'application/json',
url: 'Default.aspx/GetData',
data: "{name:'" + $("#SearchText").val() + "'}",
success:
function (response) {
drawVisualization(response.d);
}
});
return false;
})
function drawVisualization(dataValues) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Column Date');
data.addColumn('number', 'Column Value');
for (var i = 0; i < dataValues.length; i++) {
data.addRow([dataValues[i].Date, dataValues[i].Value]);
}
new google.visualization.LineChart(document.getElementById('visualization')).
draw(data, { title: "" });
}
</script>
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Visual Search Testing with 'iFrame
</h2>
<asp:Label ID="Label1" runat="server" Text="Name/Ids"></asp:Label>
<asp:TextBox ID="SearchText" runat="server" ClientIDMode="Static"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Search" onclick="Button1_Click" ClientIDMode="Static" />
<div id="visualization" style="width: 600px; height: 400px;" runat="server"></div>
</asp:Content>
default.cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Data.SqlClient;
using System.Text;
using System.Collections.Generic;
using System.Web.Services;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static List<Data> GetData(string name)
{
List<Data> dataList = new List<Data>();
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 0, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 78, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 82, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 425, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 79, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 80, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 57, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("ACCDO 11A B", 2, "Sept"));
dataList.Add(new Data("ACCDO 11A B", 2, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 96.89, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 96, "Oct"));
dataList.Add(new Data("AELIS 2013-IRAR C", 97, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Oct"));
dataList.Add(new Data("AELIS 2013-IRAR C", 85, "Sept"));
return dataList.FindAll(r => r.ColumnName.Contains(name));
}
protected void Button1_Click(object sender, EventArgs e)
{
}
}
Any advice or suggestions would be very much appreciated.
Thank you so much for your time and help.
|
|
|
|
|
You've added a runat="server" to <div id="visualization" ...>. As a result, the client ID will not be "visualization"; it will be "ctl00$MainContent$visualization". As a result, you'll get a "container not defined" error from the Google script.
Either remove the runat="server", or add ClientIDMode="Static".
<div id="visualization" style="width: 600px; height: 400px;" runat="server" ClientIDMode="Static"></div>
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
hello Richard.
Thank you once again for your quick response. The code still does not work without the runat or with the clientIDMode tag. I also tired debugging the javascript but I am still unable to pin point where the code is falling.
Any advice would be most welcome.
Thank you so much.
|
|
|
|
|
The code works fine for me in Firefox 25, Chrome and IE10.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi,
Are you able to see the charts when submitting the search input? Would you mind me asking, what Visual studio you are using? I shall keep trying on my end.
Thank you so much for your help.
Kind regards
|
|
|
|
|
I'm using .NET 4.5.1 and a text editor. As long as you're using .NET 4.0 or higher, it shouldn't make any difference.
Are you seeing an empty chart? The String.Contains method[^] is case-sensitive, so if you type "clavs" you'll get no data back. If you want a case-insensitive search, try using the IndexOf method[^]:
[WebMethod]
public static List<Data> GetData(string name)
{
var dataList = new List<Data>();
...
return dataList.FindAll(r => r.ColumnName.IndexOf(name, StringComparison.CurrentCultureIgnoreCase) != -1);
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi richard,
I really appreciate your support and time into this but for some strange reason, I am still seeing an empty chart whenever I trigger the search function on the client-side.
I changed the search code line from string to index function as you suggested, however still no result. I do not mind it being case sensitive or not. Whenever I type in "CLAVS 2007-1 M2A" into the search textbox, I am still getting a blank page.
Many Thanks
|
|
|
|
|
Strange - the code works fine for me. The only difference I can see is the base class for your Data class. Try removing it in case there's something odd with the serialization.
public class Data
{
public string ColumnName;
public double Value;
public string Date;
public Data(string name, double price, string date)
{
ColumnName = name;
Value = price;
Date = date;
}
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hello Richard.
Sadly, I am still unable to get the charts to display using the search criteria. 
I also noticed, my data.cs file is under App_code, could this be issuing the blank charts on the client-side.
I really appreciate your help and time.
Thanks a million.
|
|
|
|
|
I doubt having the file under App_Code would make any difference.
Here's the entire file I'm using to test. I have a different master page, a different file name, and I'm not using a code-behind, but otherwise everything should be the same:
<%@ Page Language="C#"
MasterPageFile="~/_controls/Site.master"
Title="Chart Test"
%>
<%@ Import Namespace="System.Web.Services" %>
<script runat="server">
public class Data
{
public string ColumnName;
public double Value;
public string Date;
public Data(string name, double price, string date)
{
ColumnName = name;
Value = price;
Date = date;
}
}
[WebMethod]
public static List<Data> GetData(string name)
{
var dataList = new List<Data>();
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 0, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 78, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 82, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 425, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 79, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 80, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 57, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("ACCDO 11A B", 2, "Sept"));
dataList.Add(new Data("ACCDO 11A B", 2, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 96.89, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 96, "Oct"));
dataList.Add(new Data("AELIS 2013-IRAR C", 97, "Sept"));
dataList.Add(new Data("AELIS 2013-IRAR C", 95, "Oct"));
dataList.Add(new Data("AELIS 2013-IRAR C", 85, "Sept"));
return dataList.FindAll(r => r.ColumnName.IndexOf(name, StringComparison.CurrentCultureIgnoreCase) != -1);
}
</script>
<asp:content runat="server" contentPlaceHolderID="bodyContentPlaceholder">
<form runat="server">
<asp:Label ID="Label1" runat="server" Text="Name/Ids"/>
<asp:TextBox ID="SearchText" runat="server" ClientIDMode="Static"/>
<asp:Button ID="Button1" runat="server" Text="Search" ClientIDMode="Static" />
<div id="visualization" style="width: 600px; height: 400px;" runat="server" ClientIDMode="Static"></div>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript" src="//www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1', { packages: ['corechart'] });
</script>
<script type="text/javascript">
$('#Button1').click(function () {
$.ajax({
type: 'POST',
dataType: 'json',
contentType: 'application/json',
url: 'chart.aspx/GetData',
data: "{name:'" + $("#SearchText").val() + "'}",
success:
function (response) {
drawVisualization(response.d);
}
});
return false;
});
function drawVisualization(dataValues) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Column Date');
data.addColumn('number', 'Column Value');
for (var i = 0; i < dataValues.length; i++) {
data.addRow([dataValues[i].Date, dataValues[i].Value]);
}
new google.visualization.LineChart(document.getElementById('visualization')).
draw(data, { title: "" });
}
</script>
</form>
</asp:content>
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
