Moving to SQL

[Gkirkup]

I have a large application presently (spilt database) in Access 2010 and accdb. We are considering moving to SQL.
- Are there any programming changes needed for SQL?
- How would I create a test back end in SQL? Do I simply use the SQL command in Access, or do I need hosting, or anything?

Robert

 

[Rx_]

http://www.access-programmers.co.uk/forums/showthread.php?t=223173&highlight=sql+server+assistant
This is over a year old now. There might be a newer download version. The concept is the same.
Microsoft SQL Server Migration Assistant for Microsoft Access
I still design new tables locally, then use this to just append them to SQL Server. It is a huge time saver.
My personal preference (not every one agrees on this one) is to use the SQL Server Native Client. It is a free download that in my humble opinion enhances the standard ODBC for linked tables.

Once you take this step, why not use programming to connect with a DNS-Less connection? Here is an example:
http://www.access-programmers.co.uk...p?t=254766&highlight=SQL+Server+native+client

My SQL Server back end has a name MyBackEndDB then there is a Test DB named MyBackEndDBT.

SQL Server can take production and create a back end very quickly. Then my DSN-Less code chooses between production data or test data.

Here is a shameless plug of my list of where to find SQL Server Native Client and other useful links.
Bottom line, make this jump to SQL Server. Then... bug them to deploy via Citrix.
http://www.access-programmers.co.uk...p?t=247756&highlight=SQL+Server+native+client

 

[Gkirkup]

Does anyone have a basic list of what I need to do to upgrade from accdb to SQL? For instance, do I buy SQL for the server first? Then is there an automated upgrade? What are the steps?

Robert

 

[Rx_]

Is this for you, your company, ...?
If you are going with a server, are you choosing server 2008, 2010..???

https://mspartner.microsoft.com/en/us/Pages/Membership/action-pack-subscriptions.aspx
It might be worth your company's time (or you) to explore the MAP program from Microsoft.
The beginner program includes downloads for the Servers, SQL Server, MS Office and much more. It does require a license fee each year. But, having all the software at your fingertips might be worth while. It also includes some beneficial Planning, Training, and Technical content.

For my home based business (1 server, 4 Workstations, three remote assistants...) the cost is worth it.

 

[Gkirkup]

Yes, this is for a business, with about 30 users. I am not involved with the servers though, I am strictly an application programmer. Moving from accdb to SQL seems like a very big task to me.

Robert