Connecting Tech Pros Worldwide Forums | Help | Site Map

transferring?/

Newbie
 
Join Date: Nov 2006
Posts: 13
#1: Nov 14 '06
hi all,
i have been using MS Access for my database. and designing pages in asp.net also. I am using the OLEDB connection, but i have everywhere read that using SQL is best. I have got installed my SQL Server 2005. BUt don't know how to proceed. Do I have to make my database in SQL all over again?? or can it be transferred?
actually im a bit confused also, I have the SQL Server installed, so where should i write my database?? kindly help?

NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,730
#2: Nov 14 '06

re: transferring?/


I would not personally recommend using SQL Server unless you are (very) experienced in either Microsoft back-end software or other back-end SQL servers.
The level of help you will need is more than I would expect you can find here.
When I say 'using' SQL Server, let me clarify - I mean maintain or look after. Using one maintained by your IT department is fine.

As for your question, unless you have experience working in MSSQL itself, I suggest you set up your tables and link to them remotely using an ODBC connection (linked tables etc).

Trying to maintain a MS SQL server is certainly not for the faint-hearted.
msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,885
#3: Nov 15 '06

re: transferring?/


Quote:

Originally Posted by NeoPa

I would not personally recommend using SQL Server unless you are (very) experienced in either Microsoft back-end software or other back-end SQL servers.
The level of help you will need is more than I would expect you can find here.
When I say 'using' SQL Server, let me clarify - I mean maintain or look after. Using one maintained by your IT department is fine.

As for your question, unless you have experience working in MSSQL itself, I suggest you set up your tables and link to them remotely using an ODBC connection (linked tables etc).

Trying to maintain a MS SQL server is certainly not for the faint-hearted.

You should know.

I must admit I have Microsofts free version but I only use it for customer dumped sql files when I have to work on enhancing and troubleshooting their frontends.
Reply