Unanswered: Transferring MSDE database to SQL Server 7
I am developing a client server application using MSDE 2000 and a Microsoft Access 2000 Project. It is going to end up running on SQL Server 2000. However I can't seem to be able to get a backup of the database structure in order to transfer it to the server ( I am developing it on my laptop.) I have tried using the backup database utility in the Access Project but it says that it needs to be connected to a proper SQL Server database. Can anyone help please?
Q1 Is there any way of extracting the definition of the database in Transact SQL form?
A1 Yes. (Ispaleny is correct.)
You may wish to consider examining / adjusting scripting options.
Scripting options may be set to include (or exclude) certain clauses, statements, etc., etc., etc.. Doing so may save considerable script editing time / effort by providing control over what is / is not included in scripted output e.g.(ON filegroup clauses, declarative referential integrity constraints, identity property including seed / increment, extended properties, conditional existence / removal statements, etc.). For example:
In QA (Tools-->Options: Script Tab), it may be easiest to script some sample ddl to new windows until the scripting options are set to meet current requirements.