Sponsored Content
Top Forums Web Development Ideas for site migration: How would you do it? LAMP -> something w/ Sql Server Post 302570138 by Astrocloud on Wednesday 2nd of November 2011 12:53:14 PM
Old 11-02-2011
Network Ideas for site migration: How would you do it? LAMP -> something w/ Sql Server

I'm afraid I'm going to have to migrate our entire website from Linux. There have been a number of irregularities in our MySQL database and the system that we have set up -probably isn't scalable.

Since my manager is re-envisioning (taking the moment to re-engineer) -he wants to move the database from MySQL to SQL Server 2008.

The problem for me now -since I am the "front end" is how to adapt our existing infrastructure (for however long it exists) from MySQL to SQL Server.

We are running Linux PHP 5.0 for now.

Q1: Is it possible to host SQL Server on another server; and migrate all the MySQL calls from our Website to the new server? If so, where can I read about how to do that?

Q2: Should I just forgo trying to maintain our current Linux website and migrate our entire website to Windows Server?

The reason I want to do Q1 is to avoid Q2 but only if it makes sense and is less problematic etc.
 

9 More Discussions You Might Find Interesting

1. AIX

Migration from OLD server to NEW one

Hi everybody, I want ask if it is possible to copy all storage structure (VGs, LVs & filesystems) from one server to another. In other words, I want to move my system from old server to new one, so I want the new server exactly have the same sizes and number of VGs, LVs, & filesystems. Thanks... (11 Replies)
Discussion started by: aldowsary
11 Replies

2. UNIX for Advanced & Expert Users

LAMP Server Failover

How does everyone else handle this? My Setup: Server A: CentOS 5.x 10.0.0.1 Apache MySQL Master Server B: CentOS 5.x 10.0.0.2 Apache MySQL Slave My Domains: dom1.com A record: 10.0.0.1 A Record: 10.0.0.2 dom2.com A record: 10.0.0.1 A Record: 10.0.0.2 (3 Replies)
Discussion started by: Ikon
3 Replies

3. AIX

How will do migration through NIM server in AIX

Can any one help..... How will do migration through NIM server? (4 Replies)
Discussion started by: AIXlearner
4 Replies

4. Solaris

Server Migration

Hi All We are having a very old server that is working on solaris 5.6 and oracle7. now We are planning to migrate it to a Solaris 8 and oracle 9 environment. The application software of the server is basically written in ProC and there are few sql ,perl and shell scripts on the server . We... (13 Replies)
Discussion started by: asalman.qazi
13 Replies

5. Shell Programming and Scripting

Server Migration: Problems with attributes

I am migrating from a host to another and I am trying to mimic the attributes on the old server. Only problem is I can't figure out a fast way. Any recommendations? Initially I thought about listing all my files on my previous host, but for some reason the listing of all files produced... (2 Replies)
Discussion started by: raykon
2 Replies

6. UNIX and Linux Applications

Server migration from samba+ldap to windows server 2003

Hi, i have a server installed samba+openldap (pdc). Need to migration windows server 2003 (active directory) object users, computers. Where you can read how to do it? Or can tell me how to do it? Thanks. P.S. Sorry for bad english (0 Replies)
Discussion started by: ap0st0l
0 Replies

7. Web Development

Building LAMP server from scratch (build a server with compiled LAMP from CentOS mini)

Hello everyone, I would like to setup a lamp server from a minimal distro and to compile PHP, MySQL and Apache myself. I have chosen CentOS minimal for the OS and I am trying to build the stack by hand... But well, it appears I need some help! First: I am looking for good and recent... (3 Replies)
Discussion started by: freddie50
3 Replies

8. AIX

Server migration

Hi, Existing several p5 server with lpar (aix5.3), also implemented with hacmp. And now planning to buy new set of server (installing aix7.1)and SAN to replace the existing server. My question is, how to perform data migration from old server/SAN to new server/SAN. Suppose I install... (6 Replies)
Discussion started by: Oceanlo2013
6 Replies

9. Solaris

Server migration - using ufsdump

hi all, i am refreshing my hardware, but i do not want to do a clean installation/reinstallation. I am wondering if i could do - do a ufsdump of the / partition (into a file on a nfs share) - bootup using cdrom in the new machine - mount the boot device/slice, and restore the ufsdump on... (7 Replies)
Discussion started by: javanoob
7 Replies
MYSQLD(8)						       MySQL Database System							 MYSQLD(8)

NAME
mysqld - the MySQL server SYNOPSIS
mysqld [options] DESCRIPTION
mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as log files and status files. When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients. The mysqld program has many options that can be specified at startup. For a complete list of options, run this command: shell> mysqld --verbose --help MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server also has a set of status variables that provide information about its operation. You can monitor these status variables to access runtime performance characteristics. For a full description of MySQL Server command options, system variables, and status variables, see Section 5.1, "The MySQL Server". For information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing and Upgrading MySQL. COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Oracle Corporation (http://dev.mysql.com/). MySQL 5.5 01/30/2014 MYSQLD(8)
All times are GMT -4. The time now is 04:11 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy