Split a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access2K database that I want to move the back-end of it to SQL
server, is that possible? Please elaborate.

Thanks
 
Yes, it is possible. It may well be beyond the scope of a newsgroup posting
though..

For starters, there is an Access Upsizing wizard that will do some of the
work for you, but not all of it.

Or, you can import the tables from SQL Server DTS services.

Its up to you whether to leave your queries in Access or convert them to SQL
Server stored procs....

Once you move the tables, you have the option of sticking with Access .MDB
for the fornt-end or an Access Data Project (.adp).

HTH,

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
 
Back
Top