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 |
|
sulrich
Starting Member
3 Posts |
 Posted - 2010-01-12 : 13:11:29
|
| I am fairly new to SQL and having a few problems moving my Access 07 DB to our SQL 2005 server. To begin, the Access DB is in shambles, it is one massive table that will no longer sync with all the replicas. The users that managed it have ended up loosing the master copy and have all been working with their own copy of the DB that hasn't been sync'd since June 09. I am working on getting what they have onto a SQL server to eliminate the need for replicas. I have been able to upsize it to SQL with fairly minor problems that I have been able to resolve, but my main question is that I am trying to split the one massive table into smaller more manageable relational tables. I have seen a few posts elsewere that have queries but I tried a few to no avail. I don't know if it is cause I am just writing them wrong or what. Can anyone please give some guidance? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-12 : 13:13:54
|
quote:
but my main question is that I am trying to split the one massive table into smaller more manageable relational tables. I have seen a few posts elsewere that have queries but I tried a few to no avail. I don't know if it is cause I am just writing them wrong or what.
Please show us what you mean.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
sulrich
Starting Member
3 Posts |
Posted - 2010-01-12 : 13:24:43
|
| This was posted on another site and no matter what I did, I kept getting a syntax error, and I believe since this is my first experience with writing a SQL query, I am obviously not doing something properly INSERT INTO <NEW_TABLE_NAME>( column_1_name, column_2_name, ...., column_n_name)select , b.column_1_name, b.column_2_name,...., b.column_n_nameFROM <BIG_TABLE_ NAME> AS b;I am trying to move the Address, city, state and zip from the access table Prospects to the table I created in SQL, tblAddress. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sulrich
Starting Member
3 Posts |
Posted - 2010-01-12 : 14:02:37
|
| INSERT INTO <TBLADDRESS> (Address, City, Street, Zip_Code) select, b.Address, b.City, b.Zip, b.Zip_Code FROM <PROSPECTS> AS b; |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Moving Access to SQL