How can I create a sample SQL-Database that only contains one company “CRONUS.NET” and with tablenames that don’t have a companyname$-prefix? I would like to use this database for documentation, training and sample SQL / .NET / ODBC access. Renaming then Company Name Table “2000000006 - Company.Name” does not allow empty names and I did not find any Option in the create Database oder create Company Dialogs.
I think there is no standard way. Only way is to create another database and create views for all tables… Or, you must change DataPerCompany to No for all tables…
This is just the way that companies are implemented in the Navision SQL Server option. Instead of trying to cheat the system out of its standard implementation, maybe you could consider simply including this fact into your documentation. If you are doing a training on C/ODBC connectivity, the company name is one of the things you need to consider when writing the connection string into standard Navision tables.
You can also create views in SQL and use those in your other apps and documentation.
There is no direct way to do this, instead you can use SQL statements which is formatted for the complete table name with prefix$ and company name, an example to use in VB is adoRS.Source = “SELECT * FROM dbo.[Cronus Products Inc_$Buffer]” where “Buffer” is the actual name of the table and “Cronus Products Inc.” is the name of the company in Navision.