Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
starBlade
Starting Member
1 Post |
 Posted - 2005-03-08 : 01:54:01
|
| Hi, I'm new to SQL. I would like to convert hundreds of Access records to SQL so that I can run queries on an SQL server.I know that I can go to View-SQL in the Access Query window but I was wondering if I could simply copy the code from Access and paste it into an access tool like the Server Query Analyzer.In general, is it a difficult thing to do converting an access database to an SQL database? |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-03-08 : 03:34:19
|
| If you just want to move your tables then it's relatively straightforward. Moving Queries will probably mean they will need tweaking at best re-writing at worst. However SQL Server is much more than just a storage place for tables and queries, I don't think there will be a quick fixsteveAnd how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-08 : 08:34:08
|
| Move the data from Access to SQL; change the Access "database" to reference the tables from SQL instead of "locally", and your queries will continue to work, won't they?Kristen |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-03-09 : 05:21:31
|
| Kristen you're right. That's how the app I have to support works.I got the impression that he wanted to move the queries onto the serversteveAnd how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-09 : 06:24:54
|
"I got the impression that he wanted to move the queries onto the server"Me to ...  Kristen |
|
|
|
|
|
|
Converting from Access to SQL