NTS Forums

Please login or register.

Login with username, password and session length
 

News:

Welcome to the Newtek Technology Services Forum!


Author Topic: Database forum FAQs  (Read 18168 times)

Jon E [CT]

  • Guest
Database forum FAQs
« on: November 09, 2006, 12:21:34 AM »
Q.  What is the current version of MySQL?
A.  MySQL 4.1.20 and 5.0.27.

Q.  Do we support SQL Server 2005 Express?
A.  No, we do not.  We offer the full version of SQL Server 2005.

Q.  What is the current version of SQL Server?
A.  We offer both SQL 2000 and SQL 2005.

Q.  What are some programs I can use to manage my MySQL or SQL Server database?
A.  For SQL Server 2000 and 2005 the most commonly used applications are those created by Microsoft.  Enterprise Manager and SQL Server Management Studio.

Enterprise Manager can be obtained by installing the client tools from the SQL Server 2000 Evaluation Edition found at http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=D20BA6E1-F44C-4781-A6BB-F60E02DC1335

SQL Server Management Studio Express can be downloaded from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

For third party applications, please visit the following links - note that some of them may require a fee depending on the license/features you require.

MySQL:

http://www.sqlmanager.net/en/products/mysql/manager
http://www.phpmyadmin.net/home_page/
http://www.webyog.com/en/
http://www.navicat.com/
http://www.mysql.com/products/tools/administrator/
http://heidisql.com/

SQL Server:

http://www.sqlmanager.net/en/products/mssql/manager

Q.  Are there any conversion utilities to migrate my Access database to SQL Server or MySQL?
A.  Yes!  Access 2003 and previous versions actually have an Upsizing Wizard inside the Access program itself.  In Access 2003, it's under Tools, Database Utilities, Upsizing Wizard.  All you need to do is create a Datasource on your local machine and point it to the SQL Server you create your database on through the Control Center, authenticate with the SQL Server username and password you specified for your database, click through the wizard and that's it!  You'll be prompted with a window to select the tables you want to export over to the SQL Server database, what attributes you want to upsize (including index, validation rules, defaults, table relationships, etc) at which point the wizard will have all the information it needs to transfer all this information to the SQL Server database; press Finish and watch the magic happen.

If MySQL is more your style, MySQL actually offers a migration Toolkit to migrate Access, SQL Server, and Oracle databases to MySQL.  Information on this toolkit can be found here:  http://www.mysql.com/products/tools/migration-toolkit/

Access Migration Tutorial:  http://www.mysql.com/products/tools/migration-toolkit/tutorials/AccessMigrationTutorial.html
Documentation: http://dev.mysql.com/doc/migration-toolkit/en/index.html
Download: http://dev.mysql.com/downloads/migration-toolkit/1.0.html
Migration Toolkit forum: http://forums.mysql.com/list.php?104
Bug tracker: http://bugs.mysql.com/

Third party conversion tools:

http://www.bullzip.com/products/a2m/info.php - free
http://www.convert-in.com/acc2sql.htm - not free

Note:  In order to create a datasource to a MySQL server you'll need the MySQL driver, which can be obtained here:  http://dev.mysql.com/downloads/connector/odbc/3.51.html

If anyone has additional recommendations on what might be helpful to include in here, please let me know.

Thank You,
 
Jon M. Ernster
Server Administrator II
CrystalTech Web Hosting Inc.
A Newtek Business Services Company
Toll Free: 1-877-323-4678
Phone: (602) 263-0300
Fax: (602) 263-0600
URL: http://www.crystaltech.com


**Both "CrystalTech Web Hosting" and "Newtek Business Services" are trademarks of Newtek Business Services, Inc.**
« Last Edit: November 17, 2008, 08:44:19 AM by Derek [CT] »

Offline LocalBandNetwork

  • Hosting Newbie
  • *
  • Posts: 9
  • Karma: +1/-0
    • http://wwwlocalbandnetwork.com
Database forum FAQs
« Reply #1 on: March 01, 2007, 04:17:30 AM »
I have a suggestion for an FAQ. When is the upgrade to mySQL 5?

Thanks
John Fitzgerald
Local Band Network
www.localbandnetwork.com

Offline aengla01

  • Hosting Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
Database forum FAQs
« Reply #2 on: March 18, 2007, 07:10:28 PM »
my FAQ suggestion (as potential customer)

What are the specs of the box/farm running the shared MSSQL DBs?

thanks

Offline dinkum

  • Hosting Newbie
  • *
  • Posts: 87
  • Karma: +0/-0
    • http://www.scotandamy.com
Re: Database forum FAQs
« Reply #3 on: July 23, 2007, 10:24:34 AM »
I recommend in your FAQ section you add a list of programs that Mac OS X users can use to access their CT databases. I know the Mac database admin is rare, but they do exist.  =-)  I went through a trial and error period a bit earlier this year and know what's out there, if you'd like some input.

Derek [CT]

  • Guest
Re: Database forum FAQs
« Reply #4 on: July 23, 2007, 12:45:31 PM »
I recommend in your FAQ section you add a list of programs that Mac OS X users can use to access their CT databases. I know the Mac database admin is rare, but they do exist.  =-)  I went through a trial and error period a bit earlier this year and know what's out there, if you'd like some input.

We'd love some input. Either post in this topic or send your info in to support. Thanks!

Offline ortho

  • Hosting Newbie
  • *
  • Posts: 44
  • Karma: +1/-2
Re: Database forum FAQs Case Sensitivity of table names
« Reply #5 on: September 15, 2007, 08:27:49 AM »
I am using a MySql 5 db successfully transferred from MsSql with the migration kit. It works just fine with my CF application, except for having to match the case of table names in all <cfquery> tags. I guess CT runs Linux for MySql.

I have installed MySql on my local Windows development machine but notice that it has no such table name case sensitivity -- a problem since that means I cannot test locally.

I have tried putting lower_case_table_names=0 in the my.ini file but it has not effect.

Any suggestions as to how to set up windows?

Thanks.
« Last Edit: September 17, 2007, 11:04:01 AM by ortho »

Offline joshdvx

  • Hosting Newbie
  • *
  • Posts: 22
  • Karma: +0/-1
Re: Database forum FAQs
« Reply #6 on: January 22, 2008, 09:18:38 PM »
I recommend in your FAQ section you add a list of programs that Mac OS X users can use to access their CT databases. I know the Mac database admin is rare, but they do exist.  =-)  I went through a trial and error period a bit earlier this year and know what's out there, if you'd like some input.

We'd love some input. Either post in this topic or send your info in to support. Thanks!


I use the MYsql toolkit, it has my admin and query tool.  This seems to be only somewhat decent one that I have found, and both tools are very prone to crashing or timeingout and freezing.

The one issue I have is that the osx version does not come with the mirgration toolkit, so I have to boot into windows to use. 

Offline kurt

  • he
  • Jr. Member
  • ****
  • Posts: 184
  • Karma: +5/-23
    • Peat Pellets and Seed Starting Supplies
Re: Database forum FAQs
« Reply #7 on: May 02, 2008, 06:59:20 AM »
This link appears to be broken:
Quote
Q.  How do I export my SQL Server 2005 Express database to a CrystalTech SQL Server 2005 server?
A.  Please refer to this thread and the threads included within for details:  http://www.crystaltech.com/forum/topic.asp?TOPIC_ID=14990


Offline Rose1812

  • Hosting Newbie
  • *
  • Posts: 15
  • Karma: +0/-0
Re: Database forum FAQs
« Reply #8 on: November 27, 2017, 09:40:48 PM »
You cannot edit your posts in this forum. You cannot delete your posts in this forum. You cannot post attachments in this forum. Home Forums Index