By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

transferring?/

P: 13
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?
Nov 14 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,186
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.
Nov 14 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Nov 15 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.