Moving to SQL

[Zaeed]

I'm looking at moving my db to a SQL backend..

My db is already split, so i'm unsure what I have to do to point my frontend to the SQL backend..

I'm just going to start by testing with SQL Server Desktop edition..

Any help would be greatly appreciated..

 

[Galaxiom]

I think that db is better then sql then why you want to move???

Better security and larger databases with SQL Server.

There is a import function in SQL Server. Import your backend and set the permissions.

This is the easy way.
Set up ODBC for the server on your clients.
Relink the tables via the ODBC connection.

This is the harder way.
Set up the connection string on the queries to directly work with SQL Server instead of linked tables. Once you get the easy way going you can try this on some of the queries.