How To Convert Access 2003 to MS SQL Server

[mad0maxx]

How would I convert Microsoft Access 2003 into Microsoft SQL Server by database or by this statement?

SELECT
Products.ProductName,
Customers.CompanyName,
(TitleOfCourtesy & " " & FirstName & " " & LastName) AS FormalName,
([Order Details].Quantity*[Order Details].UnitPrice*(1-[Discount])) AS ExtPrice

FROM
Products INNER JOIN
((Employees
INNER JOIN
(Customers
INNER JOIN
Orders
ON Customers.CustomerID=Orders.CustomerID)
ON Employees.EmployeeID=Orders.EmployeeID)
INNER JOIN [Order Details]
ON Orders.OrderID=[Order Details].OrderID)
ON Products.ProductID=[Order Details].ProductID

WHERE
([Order Details].Quantity*[Order Details].UnitPrice*(1-[Discount]))>5000

ORDER BY
([Order Details].Quantity*[Order Details].UnitPrice*(1-[Discount])) DESC;

 

[EagleKeeper]

If you are looking to just port the DB; SQL Server should have a utility wizard to do so.

I was able to do so using SQL7 Beta many years ago with no problems

 

[mugs]

No way in hell am I going to try to figure out what that statement is doing. Just use DTS to import the data, and then if you have to manipulate it do it within SQL Server.

 

[mad0maxx]

Originally posted by: EagleKeeper
If you are looking to just port the DB; SQL Server should have a utility wizard to do so.

I was able to do so using SQL7 Beta many years ago with no problems

How would I find this wizard? I got Visual Studio.net 2005 Proffesional (school edition) so I can do my work... or the name of the wizard so I may search for it...

 

[mugs]

Originally posted by: mad0maxx

Originally posted by: EagleKeeper
If you are looking to just port the DB; SQL Server should have a utility wizard to do so.

I was able to do so using SQL7 Beta many years ago with no problems

How would I find this wizard? I got Visual Studio.net 2005 Proffesional (school edition) so I can do my work... or the name of the wizard so I may search for it...

It's called DTS - Data Transformation Services.