If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Migrating Access 2003 data to SQL Server
I am planning to move the data portion of a client's Access 2003 database
over to SQL Server 2005. I realize that the client is going to need to purchase the software (probably going with the workgroup edition). My question is this... I'd like to get the data and the front-end (also in Access 2003) prepared off-site (on my computer at my office), but I'm obviously not going to go out and get the workgroup edition of SQL Server 2005 myself. Can I use the Express edition to accomplish this? Or does Visual Studio come with a "developer" version of SQL Server? How do I best accomplish this without having to go to their office to do it? As you can probably tell, I've had hardly any experience whatsoever with SQL Server. Any assistance would be greatly appreciated - Thank You! |
#2
|
|||
|
|||
Migrating Access 2003 data to SQL Server
=?Utf-8?B?SlJC?= wrote in
: Can I use the Express edition to accomplish this? Or does Visual Studio come with a "developer" version of SQL Server? Yes: that's what it's for (amongst other things). There has been a copy of MSDE on every MS Office product since v97 which is the same thing. It's a full version of SQL server throttled to prevent more than light use -- details vary between version but it's along the lines of four-or- so concurrent connections. That's fine for developing and even for a SOHO. How do I best accomplish this without having to go to their office to do it? As you can probably tell, I've had hardly any experience whatsoever with SQL Server. Just like that. Developing against MSDE or SQLSExpress will migrate quite happily to a full-sized server. http://msdn.microsoft.com/library/de...l=/library/en- us/dnmsde/html/msderoadmap.asp .... or find a more uptodate version! Best wishes Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reliability and Corruption | Melvis | General Discussion | 9 | October 27th, 2005 09:43 PM |
ACCESS / SQL SERVER | AYUDA DE ACCESS | General Discussion | 0 | July 9th, 2005 02:16 AM |
Q: Access DE via network | MarkD | General Discussion | 9 | August 5th, 2004 02:23 PM |
Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
TRIGGER a VIEW with SQL for a LINKED SERVER (ACCESS DB) | youssef | General Discussion | 10 | July 13th, 2004 12:00 AM |