Advantage Database server

Question

1.00/5 (1 vote)

See more:

I have a desktop Application made in visual studio 2010 with SQL SERVER now SQL server 2005 Does not work for Windows 10 Now I want to change the SQL SERVER 2005 TO ADVANTAGE DATABASE SERVER < Please tell me is it possible to install ADVANTAGE DATABASE SERVER ON WINDOWS 8 AND 10 and should i need to change the code behind like c sharp file as well or just i have to change the connection string if i change the DB from SQL SERVER 2005 to Advantage database server .

Posted 14-Oct-15 5:35am

Malikdanish

Add a Solution

Comments

ZurdoDev 14-Oct-15 11:49am

"ADVANTAGE DATABASE SERVER" - I've never heard of it. Have you checked with whomever makes the product?

Malikdanish 14-Oct-15 11:54am

Dear it exists and it is up and running http://devzone.advantagedatabase.com/dz/content.aspx?key=1

ZurdoDev 14-Oct-15 11:57am

Good. Have you asked there?

Malikdanish 14-Oct-15 12:07pm

its open ended question lolx thanks for participation

Richard Deeming 14-Oct-15 11:50am

If you're using SQL Express, it would be much easier to upgrade to a newer version of the same product:
http://downloadsqlserverexpress.com/[^]

2008 R2 and higher works fine on Windows 10.

Malikdanish 14-Oct-15 11:54am

I just want to go with Advantage database server

Richard Deeming 14-Oct-15 12:00pm

Well, there's no mention of Windows 10 in the supported platforms matrix[^], so you'd need to ask them whether it's supported.

It's a completely different platform, so depending on how you've written your code, you'll potentially have to change all of the code that talks to the database.

Malikdanish 14-Oct-15 12:08pm

thanks

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AnvilRanger · Answer 1 · 2015-10-14T05:57:00

Solution 1

If you are referring to the product from Sybase/SAP, then you are in for a great deal of work. You would need to convert all objects from MSSQL to the new db platform. This step alone could be a huge undertaking. And then depending on your code you would have to change your entire DAL.

The best approach is to look at a newer version of MSSQL.

Posted 14-Oct-15 5:57am

AnvilRanger

Comments

Malikdanish 14-Oct-15 12:16pm

I agree with you AnvilRanger , I just want to ask if some one saying me to convert a SQL server database to Advantage Database server (sybase/SAP) does it require lot of work or with using the script i can gerenate the objects like table,views,stored procedure or the syntax is different between these two also in code behind do i need lot or effort or a small effort will do the job..Please assists

AnvilRanger 14-Oct-15 13:43pm

That I cannot help you with a conversion. Your choice of this db platform is an odd one. I have no idea how widely used that product is so finding help for it could be difficult. Why are you choosing such a platform? You are much better off sticking with MSSQL or if you have to switch choose something like MYSQL.

Malikdanish 14-Oct-15 13:55pm

do you know about large footprint of SQL Server ? if you know then you got why i am migrating from

AnvilRanger 14-Oct-15 14:34pm

Yes I know about large MSSQL systems. I have worked for several billion dollar plus companies that ran large mission critical systems with billions of rows of data that handled millions of transactions per day. Are you trying to say that MSSQL is some how sub par when being used for large or important systems?

Malikdanish 14-Oct-15 14:37pm

Dear i did not said that i am new to this section having just 2 to 3 year of experience i have been asked to migrate the app from sql server to Advantage database so i asked that can i do that in a simpler fashion can i use the SQL Script for creating object in sybase Advantage database