I am trying to get everything from a table from a Lotus Domino (R5) table into a new Table in a SQL database.
I have my NotesSQL ODBC connection set up and can see everything I want to put into the LicensingSQL database using SQL Server Business Intelligence Development Studio and a query of " SELECT * FROM Licensing_Profile".
My Notes connection I've named LicensingNotes and my SQL database connection I've named LicensingSQL. I'm fairly new to SQL (I've run select and update queries on existing databases with a few basic date conversions and simple calculations).
I figure it's something simple that I just don't know. I've created a test table in the LicensingSQL so I should have the proper rights to create a table.
SELECT * INTO LicensingSQL.TestLicense FROM Licensing_Profile
but it tells me there is an error around FROM?
I've also tried a button in VB 6.0 too but can't get that right either.
Any suggestions would be appreciated.