How to migrate from MySQL 4.1 to MS SQL Express 2005

SQL Server Express

Index ‹ SQL Server

- Previous
 - 1
 - Where do I buy SQL Server Management Studio? Hi Jeffery, I`m not sure what you mean - you ask for Management Studio and there is a download link for SQL Server Management Studio Express . Or will you buy a SQL Server Standard, Enterprise or Datacenter Edition - then you have the "normal" SQL Server Management Studio. What do you want CU tosc Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 2
 - Sorting a table with numbers and letters I have renamed the numbers in the table (10 -> 0010) so all the numbers have 4 characters. Because I only need the numbers I have set a filter "BETWEEN 0 AND A". The sorting is no problem anymore. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 3
 - Error with SMO.TransferData() (Exception from HRESULT: 0xC0011008) Euan, I recieved the same error when testing the code listed above but could not trace it. As soon as I switched my server connection method it worked without a hitch( I think I mention this in the sample.) so I do not know if this is as clear cut. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 4
 - Can't uninstall SQL Server 2005 or install .NET 3.0 64bit after installing Office 2007 Well I had no response on the 64bit NET forum so I am posting here !! Windows Automatic Update has just failed to install .NET 3.0 (x64) WAU decided for itself that I needed this update Add Remove Programs reports the following (x64) programs ... .NET Framework 2.0 .NET Framework 2.0 SDK MS SQL SERVER 2005 VS2005 64bit prerequisites VS2005 64bit Remote Debugger MSinfo32 reports OS Name Microsoft(R) Windows(R) Server 2003 Standard x64 Edition Version 5.2.3790 Service Pack 2 Build 3790 Other OS Description R2 OS Manufacturer Microsoft Corporation System Name DEV-1 System Manufacturer Dell Inc. System Model Dell DXC051 System Type x64-based PC Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz BIOS Version/Date Dell Inc. A05, 31/03/2006 BTW this is a fresh install because I was completely and utterly unable to uninstall SqlServer2005 which was necessitated by foolishly installing Office 2007 (Office 2003 being no longer available!) Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 5
 - Whats the different between SQL Express & SQL Server 2005? Hi, I'm working in a small company (less than 30 user), we can't buy MSSql Server 2005: Q1: can we use the Express edtion do access our data I mean for commersial purpose.. Q2: dose the Express edition stand to (30 connection) at the same time Q3: can I add users to it Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 6
 - SQL Server Management Studio Express on Vista Home Premium (Error on attaching and detaching .mdf) I'm using Windows Authentication. The user that I am using is an Administrator. The only thing I noticed is that in Management Studio -> Server Properties -> Permissions -> BUILTIN\Administrator Connect SQL is only granted to "sa" and not to "MyPC\MyUser". How can I grant 'Connect SQL' to 'MyPC\MyUser' Temporarily, I turn-off the User Access Control for my user, reboot the PC and everything works already. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 7
 - SUM returns incorrect value in SQL Server Mobile Query ... Bug?? This might be a bug in our code. I have trouble reproducing the problem. Can you share the database (or just the schema) so that I can take a look. Thanks Pragya Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 8
 - Blocking in Analysis Services We have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 9
 - converting varchar to int It is clearly an SQL error which cannot be solved in SSRS using expressions. I'm assuming that your dataset is formed by a stored procedure, not plain SQL text. The error is because you are trying to put an invalid integer value into a table (temporary table or user table) column which is of INT datatype. If possible, get the SQL text of the stored procedure and check all insert/update statements and all the columns of INT datatype involved in it. Also check If there is an implicit conversion using CONVERT or CAST function. Shyam Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 10
 - Error - The report server cannot decrypt the symmetric key? Incorrect. Only the ecrypted information will be nuked, i.e. connection credentials, connection strings, and any secure information stored in subscriptions 每 by default this is only username & password in File Share delivery extension. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 11
 - need to determine which db is pricipal hey i did the following....Srv 1 was principal and Srv 2 was mirror....i just stopped sql services in principal and it immediately failed over to mirror coz i was having witness server......now the original principal became new mirror and original mirror became new principal...again inorder to revert back to original state i went to the db properties of the new principal and clicked failover ......immediately the new mirror reverted to original principal and new principal became original mirror........the same can also be done using T-SQL statements......sounds cool......... Alter database DBName set partner failover run it you'll get it......... Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 12
 - Different ways to set DATEFIRST This thread may help with your pursuit. You 'hould' understand the implications. Every built-in function or procedure that has anything to do with WeekDay calculations or determinations will be affected, including week of year. Obviously, day of week determiniations, and most other datetime functions 'should NOT' be adversely affected. BUT test, test, test. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 13
 - custom url not recognized i have this action.jumpto url = "javascript:void window.open('http://bklc-crm01:5555/cs/cases/edit.aspx id={" & cstr(Fields!incidentid.Value) & "}','_self')" for some reason when i use this field (incidentid.value) there is no hyperlink generated, however when i change the value to another field, the hyperlink works, what shall i be looking for, incident value is a set of number with dashes! Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 14
 - Only able to access Report Manager as Administrator There are three types of Authentification in Reporting Services: 1) Integrated Windows Authentification (Active Directory aware) is the default authentification method for the Report Server and Report Manager virtual directories. 2) Anonymous access (only suggested if used with security extensions). Anonymous access limites your ability to vary role assignment because all users will access the Report Server under the Anonymous user account. 3) Basic Authentification, which should only be used with a Secure Sockets Layer (SSL) connection because Basic Authentification sends username and passwords to the server in clear text, which could be picked up with a network sniffer. The Integrated Windows Authentification method is preferred and widely used. Your network administrator can setup Active Directory groups on the Domain Controller, which you can then grant those groups access to Reporting Services. If you network users have Unix, Mac, Novell or Linux accounts (non-Windows accounts) then you will need to go with Forms Authentification. Forms Authentification directs a request from an unauthenticated user to an HTML form, where they are prompted to enter a username and password. I have not used this method but many in this forum have and a quick search of the forum should return several useful posts. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 15
 - SQL Agent Roles IF the SQLAgent is not a part of sysadmin and that job is created by SA or any other login with SYSADMIN privileges then that login may not be able to modify the job as it is owned by SA. As referred in the article try to set the login under that role. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 16
 - error for sending(saving) data to database Form1.designer.cs namespace student { partial class Form1 { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel. IContainer components = null ; /// <summary> /// Clean up any resources being used. /// </summary> /// <param name="disposing"> true if managed resources should be disposed; otherwise, false. </param> protected override void Dispose( bool disposing) { if (disposing && (components != null )) { components.Dispose(); } base .Dispose(disposing); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this .components = new System.ComponentModel. Container (); System.ComponentModel. ComponentResourceManager resources = new System.ComponentModel. ComponentResourceManager ( typeof ( Form1 )); System.Windows.Forms. Label s_IDLabel; System.Windows.Forms. Label s_NAMELabel; System.Windows.Forms. Label s_ADDRESSLabel; System.Windows.Forms. Label s_PHONELabel; this .studentDataSet = new student. studentDataSet (); this .sTUDENTBindingSource = new System.Windows.Forms. BindingSource ( this .components); this .sTUDENTTableAdapter = new student.studentDataSetTableAdapters. STUDENTTableAdapter (); this .sTUDENTBindingNavigator = new System.Windows.Forms. BindingNavigator ( this .components); this .bindingNavigatorMoveFirstItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorMovePreviousItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorSeparator = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorPositionItem = new System.Windows.Forms. ToolStripTextBox (); this .bindingNavigatorCountItem = new System.Windows.Forms. ToolStripLabel (); this .bindingNavigatorSeparator1 = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorMoveNextItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorMoveLastItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorSeparator2 = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorAddNewItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorDeleteItem = new System.Windows.Forms. ToolStripButton (); this .sTUDENTBindingNavigatorSaveItem = new System.Windows.Forms. ToolStripButton (); this .s_IDTextBox = new System.Windows.Forms. TextBox (); this .s_NAMETextBox = new System.Windows.Forms. TextBox (); this .s_ADDRESSTextBox = new System.Windows.Forms. TextBox (); this .s_PHONETextBox = new System.Windows.Forms. TextBox (); this .sqlConnection1 = new System.Data.SqlClient. SqlConnection (); this .sqlCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlSelectCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlInsertCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlDataAdapter1 = new System.Data.SqlClient. SqlDataAdapter (); s_IDLabel = new System.Windows.Forms. Label (); s_NAMELabel = new System.Windows.Forms. Label (); s_ADDRESSLabel = new System.Windows.Forms. Label (); s_PHONELabel = new System.Windows.Forms. Label (); ((System.ComponentModel. ISupportInitialize )( this .studentDataSet)).BeginInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingSource)).BeginInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingNavigator)).BeginInit(); this .sTUDENTBindingNavigator.SuspendLayout(); this .SuspendLayout(); // // studentDataSet // this .studentDataSet.DataSetName = "studentDataSet" ; this .studentDataSet.SchemaSerializationMode = System.Data. SchemaSerializationMode .IncludeSchema; // // sTUDENTBindingSource // this .sTUDENTBindingSource.DataMember = "STUDENT" ; this .sTUDENTBindingSource.DataSource = this .studentDataSet; // // sTUDENTTableAdapter // this .sTUDENTTableAdapter.ClearBeforeFill = true ; // // sTUDENTBindingNavigator // this .sTUDENTBindingNavigator.AddNewItem = this .bindingNavigatorAddNewItem; this .sTUDENTBindingNavigator.BindingSource = this .sTUDENTBindingSource; this .sTUDENTBindingNavigator.CountItem = this .bindingNavigatorCountItem; this .sTUDENTBindingNavigator.DeleteItem = this .bindingNavigatorDeleteItem; this .sTUDENTBindingNavigator.Items.AddRange( new System.Windows.Forms. ToolStripItem [] { this .bindingNavigatorMoveFirstItem, this .bindingNavigatorMovePreviousItem, this .bindingNavigatorSeparator, this .bindingNavigatorPositionItem, this .bindingNavigatorCountItem, this .bindingNavigatorSeparator1, this .bindingNavigatorMoveNextItem, this .bindingNavigatorMoveLastItem, this .bindingNavigatorSeparator2, this .bindingNavigatorAddNewItem, this .bindingNavigatorDeleteItem, this .sTUDENTBindingNavigatorSaveItem}); this .sTUDENTBindingNavigator.Location = new System.Drawing. Point (0, 0); this .sTUDENTBindingNavigator.MoveFirstItem = this .bindingNavigatorMoveFirstItem; this .sTUDENTBindingNavigator.MoveLastItem = this .bindingNavigatorMoveLastItem; this .sTUDENTBindingNavigator.MoveNextItem = this .bindingNavigatorMoveNextItem; this .sTUDENTBindingNavigator.MovePreviousItem = this .bindingNavigatorMovePreviousItem; this .sTUDENTBindingNavigator.Name = "sTUDENTBindingNavigator" ; this .sTUDENTBindingNavigator.PositionItem = this .bindingNavigatorPositionItem; this .sTUDENTBindingNavigator.Size = new System.Drawing. Size (463, 25); this .sTUDENTBindingNavigator.TabIndex = 0; this .sTUDENTBindingNavigator.Text = "bindingNavigator1" ; // // bindingNavigatorMoveFirstItem // this .bindingNavigatorMoveFirstItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveFirstItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveFirstItem.Image" ))); this .bindingNavigatorMoveFirstItem.Name = "bindingNavigatorMoveFirstItem" ; this .bindingNavigatorMoveFirstItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveFirstItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveFirstItem.Text = "Move first" ; // // bindingNavigatorMovePreviousItem // this .bindingNavigatorMovePreviousItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMovePreviousItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMovePreviousItem.Image" ))); this .bindingNavigatorMovePreviousItem.Name = "bindingNavigatorMovePreviousItem" ; this .bindingNavigatorMovePreviousItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMovePreviousItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMovePreviousItem.Text = "Move previous" ; // // bindingNavigatorSeparator // this .bindingNavigatorSeparator.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorPositionItem // this .bindingNavigatorPositionItem.AccessibleName = "Position" ; this .bindingNavigatorPositionItem.AutoSize = false ; this .bindingNavigatorPositionItem.Name = "bindingNavigatorPositionItem" ; this .bindingNavigatorPositionItem.Size = new System.Drawing. Size (50, 21); this .bindingNavigatorPositionItem.Text = "0" ; this .bindingNavigatorPositionItem.ToolTipText = "Current position" ; // // bindingNavigatorCountItem // this .bindingNavigatorCountItem.Name = "bindingNavigatorCountItem" ; this .bindingNavigatorCountItem.Size = new System.Drawing. Size (36, 22); this .bindingNavigatorCountItem.Text = "of {0}" ; this .bindingNavigatorCountItem.ToolTipText = "Total number of items" ; // // bindingNavigatorSeparator1 // this .bindingNavigatorSeparator1.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator1.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorMoveNextItem // this .bindingNavigatorMoveNextItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveNextItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveNextItem.Image" ))); this .bindingNavigatorMoveNextItem.Name = "bindingNavigatorMoveNextItem" ; this .bindingNavigatorMoveNextItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveNextItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveNextItem.Text = "Move next" ; // // bindingNavigatorMoveLastItem // this .bindingNavigatorMoveLastItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveLastItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveLastItem.Image" ))); this .bindingNavigatorMoveLastItem.Name = "bindingNavigatorMoveLastItem" ; this .bindingNavigatorMoveLastItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveLastItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveLastItem.Text = "Move last" ; // // bindingNavigatorSeparator2 // this .bindingNavigatorSeparator2.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator2.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorAddNewItem // this .bindingNavigatorAddNewItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorAddNewItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorAddNewItem.Image" ))); this .bindingNavigatorAddNewItem.Name = "bindingNavigatorAddNewItem" ; this .bindingNavigatorAddNewItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorAddNewItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorAddNewItem.Text = "Add new" ; // // bindingNavigatorDeleteItem // this .bindingNavigatorDeleteItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorDeleteItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorDeleteItem.Image" ))); this .bindingNavigatorDeleteItem.Name = "bindingNavigatorDeleteItem" ; this .bindingNavigatorDeleteItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorDeleteItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorDeleteItem.Text = "Delete" ; // // sTUDENTBindingNavigatorSaveItem // this .sTUDENTBindingNavigatorSaveItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .sTUDENTBindingNavigatorSaveItem.Image = ((System.Drawing. Image )(resources.GetObject( "sTUDENTBindingNavigatorSaveItem.Image" ))); this .sTUDENTBindingNavigatorSaveItem.Name = "sTUDENTBindingNavigatorSaveItem" ; this .sTUDENTBindingNavigatorSaveItem.Size = new System.Drawing. Size (23, 22); this .sTUDENTBindingNavigatorSaveItem.Text = "Save Data" ; this .sTUDENTBindingNavigatorSaveItem.Click += new System. EventHandler ( this .sTUDENTBindingNavigatorSaveItem_Click); // // s_IDLabel // s_IDLabel.AutoSize = true ; s_IDLabel.Location = new System.Drawing. Point (44, 52); s_IDLabel.Name = "s_IDLabel" ; s_IDLabel.Size = new System.Drawing. Size (31, 13); s_IDLabel.TabIndex = 1; s_IDLabel.Text = "S ID:" ; // // s_IDTextBox // this .s_IDTextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_ID" , true )); this .s_IDTextBox.Location = new System.Drawing. Point (81, 49); this .s_IDTextBox.Name = "s_IDTextBox" ; this .s_IDTextBox.Size = new System.Drawing. Size (100, 20); this .s_IDTextBox.TabIndex = 2; // // s_NAMELabel // s_NAMELabel.AutoSize = true ; s_NAMELabel.Location = new System.Drawing. Point (51, 91); s_NAMELabel.Name = "s_NAMELabel" ; s_NAMELabel.Size = new System.Drawing. Size (51, 13); s_NAMELabel.TabIndex = 3; s_NAMELabel.Text = "S NAME:" ; // // s_NAMETextBox // this .s_NAMETextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_NAME" , true )); this .s_NAMETextBox.Location = new System.Drawing. Point (108, 88); this .s_NAMETextBox.Name = "s_NAMETextBox" ; this .s_NAMETextBox.Size = new System.Drawing. Size (100, 20); this .s_NAMETextBox.TabIndex = 4; // // s_ADDRESSLabel // s_ADDRESSLabel.AutoSize = true ; s_ADDRESSLabel.Location = new System.Drawing. Point (49, 122); s_ADDRESSLabel.Name = "s_ADDRESSLabel" ; s_ADDRESSLabel.Size = new System.Drawing. Size (72, 13); s_ADDRESSLabel.TabIndex = 5; s_ADDRESSLabel.Text = "S ADDRESS:" ; // // s_ADDRESSTextBox // this .s_ADDRESSTextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_ADDRESS" , true )); this .s_ADDRESSTextBox.Location = new System.Drawing. Point (127, 119); this .s_ADDRESSTextBox.Name = "s_ADDRESSTextBox" ; this .s_ADDRESSTextBox.Size = new System.Drawing. Size (100, 20); this .s_ADDRESSTextBox.TabIndex = 6; // // s_PHONELabel // s_PHONELabel.AutoSize = true ; s_PHONELabel.Location = new System.Drawing. Point (77, 160); s_PHONELabel.Name = "s_PHONELabel" ; s_PHONELabel.Size = new System.Drawing. Size (58, 13); s_PHONELabel.TabIndex = 7; s_PHONELabel.Text = "S PHONE:" ; // // s_PHONETextBox // this .s_PHONETextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_PHONE" , true )); this .s_PHONETextBox.Location = new System.Drawing. Point (141, 157); this .s_PHONETextBox.Name = "s_PHONETextBox" ; this .s_PHONETextBox.Size = new System.Drawing. Size (100, 20); this .s_PHONETextBox.TabIndex = 8; // // sqlConnection1 // this .sqlConnection1.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\Documents and Settings\\Glad\\Desktop" + "\\student\\student\\student.mdf\";Integrated Security=True;User Instance=True" ; this .sqlConnection1.FireInfoMessageEventOnUserErrors = true ; this .sqlConnection1.StatisticsEnabled = true ; // // sqlCommand1 // this .sqlCommand1.Parameters.AddRange( new System.Data.SqlClient. SqlParameter [] { new System.Data.SqlClient. SqlParameter ( "@S_ID" , System.Data. SqlDbType .Int, 0, System.Data. ParameterDirection .Output, false , (( byte )(0)), (( byte )(0)), "" , System.Data. DataRowVersion .Current, null ), new System.Data.SqlClient. SqlParameter ( "@S_NAME" , System.Data. SqlDbType .VarChar), new System.Data.SqlClient. SqlParameter ( "@S_ADDRESS" , System.Data. SqlDbType .VarChar), new System.Data.SqlClient. SqlParameter ( "@S_PHONE" , System.Data. SqlDbType .Text)}); // // sqlSelectCommand1 // this .sqlSelectCommand1.CommandText = "SELECT S_ID, S_NAME, S_ADDRESS, S_PHONE\r\nFROM STUDENT" ; this .sqlSelectCommand1.Connection = this .sqlConnection1; // // sqlInsertCommand1 // this .sqlInsertCommand1.CommandText = "INSERT INTO [STUDENT] ([S_ID], [S_NAME], [S_ADDRESS], [S_PHONE]) VALUES (@S_ID, @" + "S_NAME, @S_ADDRESS, @S_PHONE)" ; this .sqlInsertCommand1.Connection = this .sqlConnection1; this .sqlInsertCommand1.Parameters.AddRange( new System.Data.SqlClient. SqlParameter [] { new System.Data.SqlClient. SqlParameter ( "@S_ID" , System.Data. SqlDbType .Int, 0, "S_ID" ), new System.Data.SqlClient. SqlParameter ( "@S_NAME" , System.Data. SqlDbType .VarChar, 0, "S_NAME" ), new System.Data.SqlClient. SqlParameter ( "@S_ADDRESS" , System.Data. SqlDbType .VarChar, 0, "S_ADDRESS" ), new System.Data.SqlClient. SqlParameter ( "@S_PHONE" , System.Data. SqlDbType .Text, 0, "S_PHONE" )}); // // sqlDataAdapter1 // this .sqlDataAdapter1.InsertCommand = this .sqlInsertCommand1; this .sqlDataAdapter1.SelectCommand = this .sqlSelectCommand1; this .sqlDataAdapter1.TableMappings.AddRange( new System.Data.Common. DataTableMapping [] { new System.Data.Common. DataTableMapping ( "Table" , "STUDENT" , new System.Data.Common. DataColumnMapping [] { new System.Data.Common. DataColumnMapping ( "S_ID" , "S_ID" ), new System.Data.Common. DataColumnMapping ( "S_NAME" , "S_NAME" ), new System.Data.Common. DataColumnMapping ( "S_ADDRESS" , "S_ADDRESS" ), new System.Data.Common. DataColumnMapping ( "S_PHONE" , "S_PHONE" )})}); // // Form1 // this .AutoScaleDimensions = new System.Drawing. SizeF (6F, 13F); this .AutoScaleMode = System.Windows.Forms. AutoScaleMode .Font; this .ClientSize = new System.Drawing. Size (463, 266); this .Controls.Add(s_PHONELabel); this .Controls.Add( this .s_PHONETextBox); this .Controls.Add(s_ADDRESSLabel); this .Controls.Add( this .s_ADDRESSTextBox); this .Controls.Add(s_NAMELabel); this .Controls.Add( this .s_NAMETextBox); this .Controls.Add(s_IDLabel); this .Controls.Add( this .s_IDTextBox); this .Controls.Add( this .sTUDENTBindingNavigator); this .Name = "Form1" ; this .Text = "Form1" ; this .Load += new System. EventHandler ( this .Form1_Load); ((System.ComponentModel. ISupportInitialize )( this .studentDataSet)).EndInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingSource)).EndInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingNavigator)).EndInit(); this .sTUDENTBindingNavigator.ResumeLayout( false ); this .sTUDENTBindingNavigator.PerformLayout(); this .ResumeLayout( false ); this .PerformLayout(); } #endregion private studentDataSet studentDataSet; private System.Windows.Forms. BindingSource sTUDENTBindingSource; private student.studentDataSetTableAdapters. STUDENTTableAdapter sTUDENTTableAdapter; private System.Windows.Forms. BindingNavigator sTUDENTBindingNavigator; private System.Windows.Forms. ToolStripButton bindingNavigatorAddNewItem; private System.Windows.Forms. ToolStripLabel bindingNavigatorCountItem; private System.Windows.Forms. ToolStripButton bindingNavigatorDeleteItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveFirstItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMovePreviousItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator; private System.Windows.Forms. ToolStripTextBox bindingNavigatorPositionItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator1; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveNextItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveLastItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator2; private System.Windows.Forms. ToolStripButton sTUDENTBindingNavigatorSaveItem; private System.Windows.Forms. TextBox s_IDTextBox; private System.Windows.Forms. TextBox s_NAMETextBox; private System.Windows.Forms. TextBox s_ADDRESSTextBox; private System.Windows.Forms. TextBox s_PHONETextBox; private System.Data.SqlClient. SqlConnection sqlConnection1; private System.Data.SqlClient. SqlCommand sqlCommand1; private System.Data.SqlClient. SqlCommand sqlSelectCommand1; private System.Data.SqlClient. SqlCommand sqlInsertCommand1; private System.Data.SqlClient. SqlDataAdapter sqlDataAdapter1; } } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// form1.cs using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Text; using System.Windows.Forms; namespace student { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void sTUDENTBindingNavigatorSaveItem_Click( object sender, EventArgs e) { sqlConnection1.Open(); sqlDataAdapter1.InsertCommand.CommandText= "INSERT INTO STUDENT (" + "S_ID, S_NAME, S_ADDRESS, S_PHONE" + ") VALUES ('" + s_IDTextBox.Text + "', '" + s_NAMETextBox.Text + "', '" + s_ADDRESSTextBox.Text + "', '" + s_PHONETextBox.Text + "')" ; sqlDataAdapter1.InsertCommand.ExecuteNonQuery(); sqlConnection1.Close(); this .Validate(); this .sTUDENTBindingSource.EndEdit(); this .sTUDENTTableAdapter.Update( this .studentDataSet.STUDENT); } private void Form1_Load( object sender, EventArgs e) { this .sTUDENTTableAdapter.Fill( this .studentDataSet.STUDENT); } } } Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
- Next
 - 1
 - Parent - Multiple Child Package Execution Could you use two Execute Package tasks, one configured for executing on the file system, the other for the database Then use precedence constraints to control which one executes. So you'd pass in two variables - one being the connection to the package, the other setting a variable that controls which package executes. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 2
 - msdb restore on new server One more thing. According to this (reference http://support.microsoft.com/kb/915845 ): ... -- Find the jobs to update. These jobs must match all of the input -- criteria, unless all of the inputs are null. In this case, -- examine all jobs. The jobs must also be jobs created locally, -- such as sysjobs.originating_server_id = 0 . These jobs should not be a job that we run -- because another server told us to. Furthermore, if the job -- is local but it is meant to be run on a target server, we send an -- update for the job. declare @jobsToUpdate TABLE (job_id uniqueidentifier not null) insert into @jobsToUpdate select job_id from sysjobs where originating_server_id = 0 -- local jobs and ((COALESCE(@job_name, sysjobs.name) = sysjobs.name) and (COALESCE(@job_id, sysjobs.job_id) = sysjobs.job_id) and (COALESCE(@owner_name, suser_sname(sysjobs.owner_sid)) = suser_sname(sysjobs.owner_sid))) ... The originating_server_id's in sysjobs on SQL_TEST is already 0 (local jobs). If anyone has any details on how to script the Maintenance Plans then please let me know. Thanks, Mark Tabash Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 3
 - Some things about SMO Hello, Which version of SQL Server are you using ( no Job Agent with SQL Server Express ) Have a nice day Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 4
 - Add hidden field to report I was able to resolve this by using the rowcount function, and just specifying the previous list as the scope to count. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 5
 - Making Reports Customizeable for Users on a .NET site We are doing the same thing, using IFrames with the report displayed in the IFrame. We did some custom code to facilitate the moving around of the frames within a page. This really would not be 1 report, but a web page with multiple reports being displayed in multiple IFrames. HtH BobP Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 6
 - Connections through a server alias, IP address, or any other alternate name are not supported. Hi Ziad, Can you explain what you did exactly did you create the following: 1-create alisan name : mysecondserver 2-port: by default empty , you need to specify the port in case you have firewall issue. 3-protocol: TCP/IP or other.. 4-server: IP\instance_name NB: to be sure about server name on the second server select @@servername in query window on the second server. If you still cannot connect , please send me a direct email, you can find it on my site and i will try to discuss it with you. Tarek Ghazali SQL Server MVP http://www.sqlmvp.com Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 7
 - How to deliver a report dynamically based on the dataset with standard edition? I don't see a reason why this shouldn't work. You can write a script task to call down to the SSRS web service and request the report by invoking the Render method . Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 8
 - Design table need help Isn't this a self-referential ParentID relationship You can do it all in one table (I think): tbProject ProjectID int IDENTITY (1,1) (PK) ProjectName nvarchar(255) ParentProjectID int NOT NULL (FK --> projectID) TopLevelProjectID int NOT NULL (FK --> ProjectID) Requirement nvarchar(255) Create a project, it gets ProjectID = 1, and since it has no Parent, it's ParentID = 1 that means that it's a Top-Level project, so it's TopLevelProjectID = 1. A sub project would have ProjectID = 2 (or whatever the next avilable ID is), a ParentProjectID = 1, and a TopLevelProjectID = 1. And, if this sub had a sub, then: ProjectID = 3 (or next available ID) ParentID = 2 ('cause that's one level UP from this project) TopLevelProjectID = 1 ('cuase that the top of the tree from this project) With this, you can use something like: Update Set REquirment = Requirment + " SOME NEW STRING " where TopLevelProject = 1 Code Block create table #Projects ( ProjectID int identity ( 1 , 1 ) , ParentID int , TopLevelID int , ProjectName varchar ( 255 ) , ProjectRequirement varchar ( 255 ) ) insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1' , 1 , 1 , 'some thing or other' insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 2' , 2 , 2 , 'do this now' insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 3' , 3 , 3 , ' FOOBAR the 3rd' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A' , 1 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 2: Sub A' , 2 , 2 insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1: Sub B' , 1 , 1 , 'Hey, here''s another one!!' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A: Sub i' , 4 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A: Sub ii' , 4 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1: Sub A: Sub ii: Sub a:' , 8 , 1 , 'Do it. Do it now!' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 3: Sub A' , 3 , 3 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 3: Sub A: Sub i' , 10 , 3 ; with CTE as ( select ProjectName as [ProjectName] , ProjectName as [ParentProject] , ProjectName as [TopLevelProject] , convert ( varchar ( 4000 ), IsnUll ( ProjectRequirement , '' )) as [REQ] , ProjectID from #Projects where TopLevelID = ProjectID union all select P . ProjectName , cte . [ProjectName] , cte . [TopLevelProject] , convert ( varchar ( 4000 ), CTE . REQ + ': ' + isnull ( ProjectRequirement , '' )), p . ProjectID from CTE inner join #Projects P on P . ParentID = cte . ProjectID where P . ProjectID <> p . ParentID and p . ProjectID <> p . TopLevelID ) select * from CTE order by TopLevelProject , ParentProject drop table #Projects Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 9
 - Estimating hardware requirements for a SQL Server 2005 installation Is there any good online documentation describing rules of thumb for estimating and planning a SQL Server 2005 deployment in support of a Windows rich client/WCF services architecture TIA, Ian Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 10
 - Online/Offline Application that must synchronize with SQL 2005 Hi ! I must developp a WPF Application with online and offline capabilities! First I think to use XML file on the local application and transfer these XML files to a webservice that will synchronize them with the SQL 2005 Server BUT I read about "Replication"... and I think it will be much simpler to implement!!! Do you think it is a good idea to have a "local" SQL Express database and replicate it (when connection available is) with the principal database that will run a standard SQL 2005 version! Do you have another suggestion to make such an application Thanks for help!!! PlaTyPuS PS: when the sql express solution a good idea is, does it give a simple solution to programm an automatic synchronization every hour Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 11
 - SSAS - Custom Rollup in Snapshot Cube - SQL 2000 vs SQL 2005 Hi Linda, A couple of clarifications: Linda Cornerstone wrote: I tried 'Average of Children' and it does give the correct results Did you mean to say that it didn't give you the correct results (for example, this could happen if there are multiple date dimensions; or if [Snapshot Date] is not identified as a date dimension) Linda Cornerstone wrote: In the Shaphot Date dimension properties for Week, Month, Quarter and Year for CustomRollupColumn I am using dimDate.Custom Rollup There are 2 issues with this that I can see: If the Shaphot Date dimension is regular (not parent-child), the article suggests incorporating expressions in the cube MDX script at the different levels, rather than custom rollups - these would probably perform better. However, if you want to make the Custom Rollup work, the issue may be that CustomRollupColumn is an attribute rather than a dimension property . So, assuming that you've set this property separately for each of the Week, Month, Quarter and Year attributes, it's safer to explicitly specify a hierarchy in the expression, like: 'Avg([Snapshot Date].[Year-Quarter-Month-Week].CurrentMember.Children)' . But this may only work (assuming that there is a [Year-Quarter-Month-Week] hierarchy ) if it is a natural hierachy . SQL Server 2005 Books Online Attribute Relationships ... Natural Hierarchy Relationships A hierarchy is a natural hierarchy when each attribute included in the user-defined hierarchy has a one to many relationship with the attribute immediately below it. ... Relationships representing natural hierarchies are enforced by creating an attribute relationship between the attribute for a level and the attribute for the level below it. ... Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 12
 - Problem returning SQL data I'm having trouble with the display of data when I test my asp page. I basically retrieves or pulls data from different tables in a database. Based on an ID number (which I can change manually by typing in a value and appending it to the URL), it shows GuestName, GuestDescription and URL as text link. I can get it to do that much. But for some reason it's not showing the URL associated with the Guest Name. I dont think it's the display section of my code. I think it's the Select statement. Here is what the output looks like in my Firefox and IE browsers when I test. Some data has been changed to protect it's integrity: (Name in bold) Mark Crisp's author of The Bush Lexicon. His new book... Related Links: John Doe interviewed by Susan Smith, 123 News What it should say in the link is this: Mark Crisp's blog (as text link) When I test for different data I just change the end of the URL like this: defaultprogram4.asp ID=1234 (this number represents an ID column in a table) Code Snippet <% set con = Server.CreateObject("ADODB.Connection") con.Open "File Name=E:\webservice\Company\Company.UDL" set rs = Server.CreateObject("ADODB.Recordset") id=request.querystring("id") 'If this line is commented out the page will be blank. 'However you can still append a record number to the end of the URL and display that one. IF id <> "" then id=id else id="1234" end if 'This line shows the default record of 1234. If this line is commented out the page will ONLY show the default record but will NOT allow you 'to append a different number strSQL = "SELECT *, T_Programs.ID AS Expr1, T_ProgramGuests.ProgramID AS Expr2, T_ProgramGuests.GuestName AS Expr3, T_ProgramGuests.GuestDescription AS Expr4, T_ProgramLinks.URL AS Expr5, T_ProgramLinks.Description AS Expr6 FROM T_ProgramGuests CROSS JOIN T_Programs CROSS JOIN T_ProgramLinks WHERE (T_ProgramGuests.ProgramID = '" & id & "')" rs.Open strSQL,con 'open a connection to the database %> <% Response.Write RS ("GuestName") %> <% Response.Write RS("GuestDescription") %> Related Links: <li class='basic'><A HREF="<%= RS("URL") %>"><%= RS("Description") %></A></li>  <% recProgram.Close con.Close set recProgram = nothing set con = nothing %> Bottom line here is this: Why would I be seeing one name but a link not associated with that name It's as though it's reading a name from the ProgramGuests table and a URL from the ProgramLinks table (Except that: it shows a completely different unrelated URL to that name). What am I missing Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 13
 - Jump to report Navigation Can I have a report that is nothing more than a parameter and when the user selects from the list it will jump to another report based on which parameter was selected I can create a report with a text box that I can click to jump. I'd like to be able to eliminate the click on text box if possible and jump directly from parameter select pull down box. Thanks. Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 14
 - Error using /SET I have a data importing .dtsx file that I would like to point towards another server on occasion. I tried: DTEXEC /FILE "fubar.dtsx" /SET "\Package.Connections[ConnectionManagerName].Properties[ConnectionString];Data Source=NEWSVR;Initial Catalog=Fubar;Provider=SQLNCLI;Integrated Security=SSPI;Auto Translate=False;" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI but I keep getting the error: Argument ""\Package.Connections[ConnectionManagerName].Properties[ConnectionString];Data Source=NEWSVR;Initial Catalog=Fubar;Provider=SQLNCLI;Integrated Security=SSPI;Auto Translate=False;"" for option "set" is not valid. Staring at the XML within the .dtsx file gave me no insight other than I suspect the "ConnectionManagerName" is the problem. How do I figure out the magic incantation It's definitely not as trivial as using '-S NEWSVR' on SQLCMD! Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 15
 - How to remove Reporting Server Sp2 Hi Tomas, Assuming you want to move forward to a newer SP or QFE in the future, you'll want to get the root problem resolved. There may be a workaround that doesn't require rolling back to RTM/SP1, for instance. If you're comfortable sharing your report definition here and a description of the problem with the report after upgrade, please do so. Another option is to use Connect to log the problem as a product bug: http://connect.microsoft.com/SQLServer/Feedback Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005
 - 16
 - Problems with ProcessAdd and secondary DataSource We have a SSAS 2005 cube in place and have been using ProcessAdd XMLA for some time with success. The current environment has a single datasource called 'Sales' and a single DSV called 'Sales'. The sales datasource is a DB2 database. Everything works great. In preperation for adding some new data sources, we have built a version in our test environment that is configured with two data sources and a single DSV. 'Master' is the primary DS and it points to an empty DB on SQL Server. 'Sales' is a secondary DS and it points to the original DB2 database. There is a single DSV that is called 'Master'. Everything works well through SSMS, but I can't seem to build the correct XMLA to get ProcessAdd working again. If I build it with the 'Master' datasource and DSV it gives me a bunch of errors that arent specific enough for me to take action. Things like Error ErrorCode = " 3240034316 " Description = " Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DIM IBU HIER VER', Name of 'IBU' was being processed. " Source = " Microsoft SQL Server 2005 Analysis Services " HelpFile = "" If I build the xmla for ProcessAdd with the 'Sales' datasource and 'Master' DSV and then rename 'Master' to 'Sales' it appears to work and executes successfuly.. However, when you watch the activity on the profiler, it is not using the query from the out-of-line DSV query but instead it goes back to SSAS DB and uses the query stored there. All of the ProcessAdd examples I have seen seem to deal with a single DSV and DS. Can there be multiple datasources in the ProcessAdd xmla Is it possible to make this scenario work Thanks, Marty Tag: How to migrate from MySQL 4.1 to MS SQL Express 2005

Lindyman

I am trying to migrate from MySQL 4.1 to MS SQL Express 2005

1. do i need to create an empty db under Express

2. can this be done from within Express by pulling from MySQL into Express or do I need to work from command lines

3. what would be the cleanest way to approach this

I have a MySQL dump and did look at the result from within Express, but it was not an import, I would like to find a way to import if possible that data. Table by table would be fine.

Top

Re: How to migrate from MySQL 4.1 to MS SQL Express 2005

Madhu K Nair

There are couple of options available

(a) Configure Linked server and Use Select *into from SQL Server

(b) If you can do BCP OUT from MYSQL then you can do BCP IN to SQL Server

(d) Since your edition is Express SSIS is not an option

Though this link talk about DTS (which not available in express) you can still have check the data type issues

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx

Check : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=304918&SiteID=1

Madhu

Top